My problem is in excel sheet How to add or subtract a cell with a format dd/mm/yyyy hh;mm AM to another cell with the same format dd/mm/yyyy hh;mm AM
1 Answer
I guess you want the difference of those two dates in days for example (subtracting two dates).
You can achieve that with the datedif
function:
=datedif(start; end; "d")
Adding is not possible and it doesn't make sense actually. What would be the outcome if you add two dates together?
-
Indeed, adding full dates makes little sense. Adding times (without dates) might be useful, for which formats with square brackets, such as
[HH]:MM:SS]
, might be useful.– ArjanCommented Jan 7, 2017 at 12:17 -
3 Monday 2017 10:30 AM is a start date for a certain job to finish it we need 100:45 hour. How we calculate the end time per day and in what time ?? Commented Jan 7, 2017 at 15:01
-
@MohamedAdelAbdelazeez just add the two cells together, if that does not work then your date is a text string that looks like a date. If that is the case you will need to parse the string to create a true date/time value. Commented Jan 7, 2017 at 15:49