Discussion Locked

time value problem in excel

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm creating a staff clocking in system in Excel and having calculated in hours and minutes the time a member of staff has worked in a day i now need to be able to calculate amount of time in hours and minutes a member of staff has worked over 7.5 hours. Have tried various methods without success. Can anybody help? thanks

3 replies

by pvp

start stop actual reg ot
14:00 22:00 8:00 7:30 0:30

I'd hide the actual column; I just use it to simplify the ensuing formulae.

Its formula is "=b2-a2".

The formula for reg is "=IF(B2>(7.5/24),7.5/24,B2)".

The forumula for ot is "=IF(C2>(7.5/24),C2-(7.5/24),0)".

I'm guessing you left out the "/24" :)

This discussion is closed to new replies.