General discussion

Locked

time value problem in excel

By dprtech ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

time value problem in excel

by pVp In reply to time value problem in exc ...

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" :)

Collapse -

time value problem in excel

by dprtech In reply to time value problem in exc ...
Collapse -

time value problem in excel

by dprtech In reply to time value problem in exc ...

This question was closed by the author

Back to Windows Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums