Thread
:
Subtracting dates
View Single Post
#
3
Posted to microsoft.public.excel.misc
Ardus Petus
external usenet poster
Posts: 718
Subtracting dates
typo!
=24*(A2-A1)
Cheers,
--
AP
"Sloth" a écrit dans le message de news:
...
To get a result in decimal hours (ie. 35.25 equals 35 hours and 15
minutes):
=24(A2-A1)
format the cell as a number.
To get a result in Excel time (ie. 35:15):
=A2-A1
format the cell like this...
[h]:mm
"toot033" wrote:
Is there a way to subtract 2 dtes and have the result come out in hours?
I am looking for a way to show the time difference between dates but it
has
to be show in hours. I have tried formating the cell after doing this
subtraction but this wont work.
Thanks in Advance.
Reply With Quote
Ardus Petus
View Public Profile
Find all posts by Ardus Petus