Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting dates
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting dates
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting dates
oops. Good eye Ardus
"Ardus Petus" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting time part of a Date, subtracting dates | Excel Discussion (Misc queries) | |||
Subtracting Dates | Excel Discussion (Misc queries) | |||
subtracting dates | Excel Discussion (Misc queries) | |||
Subtracting dates to get hours... but I want to skip weekends | Excel Discussion (Misc queries) | |||
Dates Subtracting dates. | Excel Discussion (Misc queries) |