Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can we calculate the numbers of hours between two dates and
i need to calculate the exact number of hours between two different dates and
times, e.x. 04/12/10 10:23 AM and 04/15/10 15:18. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can we calculate the numbers of hours between two dates and
=B1-A1, format Custom as [h]:mm
-- Kind regards, Niek Otten Microsoft MVP - Excel "Rama Chandra" <Rama wrote in message ... i need to calculate the exact number of hours between two different dates and times, e.x. 04/12/10 10:23 AM and 04/15/10 15:18. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can we calculate the numbers of hours between two dates and
=(+A2-A1)*24
-- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Rama Chandra" wrote: i need to calculate the exact number of hours between two different dates and times, e.x. 04/12/10 10:23 AM and 04/15/10 15:18. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can we calculate the numbers of hours between two dates and
Subtract the earlier value from the later one and then use Format -- Custom
format: [h]:mm:ss For example with 04/12/10 10:23 AM in A1 and 04/15/10 15:18 in B1 then =B1-A1 and with the custom formatting applied will display 76:55:00, which is 76 hours and 55 minutes. "Rama Chandra" wrote: i need to calculate the exact number of hours between two different dates and times, e.x. 04/12/10 10:23 AM and 04/15/10 15:18. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can we calculate the numbers of hours between two dates and
If you would rather have the result as a decimal number (76.91667 hours for
the previous example), then =(B1-A1)*24 and format the cell as either General or one of the Number formats. "Rama Chandra" wrote: i need to calculate the exact number of hours between two different dates and times, e.x. 04/12/10 10:23 AM and 04/15/10 15:18. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate working hours between two dates | Excel Discussion (Misc queries) | |||
How to calculate Hours between two dates? | Excel Discussion (Misc queries) | |||
Calculate hours between to separate dates and times | New Users to Excel | |||
Calculate work hours between two dates | Excel Worksheet Functions | |||
How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions |