Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I need to calculate the difference between two dates/times. The date/time is entered in this format: 12/12/07 3:52 PM When I simply subtract the end date from the start date, it gives me a number in days with two-digit decimal place for partial day (e.g., 5.01). Is there a way to format the cell or add to my simple formula (=B2-A2) to convert the number into days/hours/minutes of some kind? I've been experimenting without much luck, and didn't see a posting that was specific to this issue. Thank you in advance, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I calculate dates and times, w/answer of days & hours | Excel Worksheet Functions | |||
Need difference between two dates/times in hours | Excel Worksheet Functions | |||
find days and hours between 2 sets of dates and times | Excel Discussion (Misc queries) | |||
HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions | |||
How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions |