Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating time interval (some across midnight)
I need to calculate two columns of time. Most entries fall within the
same day's 24 hour limit, so a simple forumla "=b1-a1" will do. But a few in the 2nd column will cross midnight. I could only find tips on formatting the result of such substracting in the Excel Help file. The example used falls within the same day. The example used in the Help file has both the date AND the time in the same cell: "mm/dd/yy hh:mm." In both columns of mine, the time is formatted as "hh:mm:ss" only. So I changed an entry to the same format used in the Help file, which didn't seem to make a difference. Thanks in advance, Adam T. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating time interval (some across midnight)
JE:
Thank you for your quick response. I applied your method and it appears to fix the problem! Adam. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating time interval (some across midnight)
If cell A1 is your starting time, cell B1 is your ending time, try this
formula in cell C1: =IF(A1B1, B1-A1+24, B1-A1) " wrote: I need to calculate two columns of time. Most entries fall within the same day's 24 hour limit, so a simple forumla "=b1-a1" will do. But a few in the 2nd column will cross midnight. I could only find tips on formatting the result of such substracting in the Excel Help file. The example used falls within the same day. The example used in the Help file has both the date AND the time in the same cell: "mm/dd/yy hh:mm." In both columns of mine, the time is formatted as "hh:mm:ss" only. So I changed an entry to the same format used in the Help file, which didn't seem to make a difference. Thanks in advance, Adam T. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells with time format and calculating the diffrence | New Users to Excel | |||
Calculating Clock start time in Excel | Excel Discussion (Misc queries) | |||
convert interval to various separate date , time, hr, minutes | Excel Worksheet Functions | |||
I need help with a formula calculating time | Excel Discussion (Misc queries) | |||
calculating with a time format cell | Excel Worksheet Functions |