Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hours between date/Time
I have information in the following format:
A1 - 2/29/2008 15:00:00 PM B1 - 3/3/2008 3:42:00 AM I am trying to calculate the hours in between and come up with a numeric value (ie 47). The data come to me in this format from another application. Thanks for the help -- Brooks W. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hours between date/Time
Maybe
=B1-A1 Formatted as [hh]:mm but it will give an answer of 60:42, why do you think it should be 47? Mike "Brooks W." wrote: I have information in the following format: A1 - 2/29/2008 15:00:00 PM B1 - 3/3/2008 3:42:00 AM I am trying to calculate the hours in between and come up with a numeric value (ie 47). The data come to me in this format from another application. Thanks for the help -- Brooks W. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hours between date/Time
If you're looking for the time difference, the formula is =B1-A1 formatted
as [h]:mm:ss In this case the result is 60:42:00 Or did you want just the hours which would be =INT(B1-A1)*24+INT(((B1-A1)-INT(B1-A1))*24) formatted as general In this case the result is 60 Tyro "Brooks W." wrote in message ... I have information in the following format: A1 - 2/29/2008 15:00:00 PM B1 - 3/3/2008 3:42:00 AM I am trying to calculate the hours in between and come up with a numeric value (ie 47). The data come to me in this format from another application. Thanks for the help -- Brooks W. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting more than 24 hours from a Date/Time | Excel Worksheet Functions | |||
join date & time & add hours | Excel Worksheet Functions | |||
Time/Date subtract 24 hours | Excel Discussion (Misc queries) | |||
How do I add 12 business hours to the current date/time? | Excel Worksheet Functions | |||
How do I add 12 business hours to the current date/time? | Excel Worksheet Functions |