Remember Me?

#1
April 4th 05, 01:43 AM
 DP01 Posts: n/a
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
April 4th 05, 01:57 AM
 Ragdyer Posts: n/a

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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post taxmom Excel Worksheet Functions 3 March 2nd 05 03:35 PM Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM Damian Excel Worksheet Functions 1 January 7th 05 04:16 AM Huge project Excel Worksheet Functions 0 December 28th 04 01:27 AM o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM

All times are GMT +1. The time now is 01:33 PM.