Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula for finding the differance between two times
I'm trying to find a formula that gives me the hh:mm between a start and
finish time of any shift, regardless of if it crosses over midnight, eg: 20:00 to 02:00. I have found formula's that give an answer of 20:00 to 02:00 = 20:00, but I need a result like 20:00 to 02:00 = 6:00. Any Suggestions? |
#2
|
|||
|
|||
Start time in A1
End time in B1 =((B1-A1)+(A1B1))*24 Format the cell as "General" -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "DP01" wrote in message ... I'm trying to find a formula that gives me the hh:mm between a start and finish time of any shift, regardless of if it crosses over midnight, eg: 20:00 to 02:00. I have found formula's that give an answer of 20:00 to 02:00 = 20:00, but I need a result like 20:00 to 02:00 = 6:00. Any Suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |