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? |
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? |
All times are GMT +1. The time now is 03:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com