Time Calculation part 2

[Dbeethekidd]

Hi Again

As an addition to my current works, i am trying to calculate the lunch break times of my staff.

What i'm looking for is something like this.

Cell 1 = Clocking out time (example 12:00)
Cell 2 = Clocking back in time (example 12:55)
Cell 3 = Total number of minutes taken (cell 2 - cell 1)
Cell 4 = The difference either side of the hour (+5 minutes as they didn't take the full hour)

If this doesn't make any sense, i will try to upload a copy of my SS.

Many thanks again

DB

[DonkeyOte]

If we assume cell 1 is A1, cell 2 is A2 then cell 4

="01:00"-(A2-A1)

Note you can't display negative time values (unless running 1904 Date System (not advised)) so you may choose to multiply by 1440 to get the value in decimal format or alternatively

=REPT("-",A2>(A1+"01:00"))&TEXT(ABS("01:00"-(A2-A1)),"[h]:mm")

but result is then text

[daddylonglegs]

If clock out time is A2 and clock in B2 then try like this in C2

=ROUND(60-(B2-A2)*1440,0)

If you actually want to see a + sign for positive values then custom format C2 as

+0;-0;0