Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm working on a Time Calculator for work. On the time cards we have two
sets of In and Out on each card. If as an example someone has clocked in at 6:00 and Clocked out at 14:00. That person has worked their 8 hours and as they start to leave a truck shows up and they decide to clock back in to unload the truck. (the company pays them 2:00 hours as show up time. I don't have a problem with people clocking in 2X and out 2X that is fairly easy ((B4-B3+(B4<B3)+(B6-B5+(B6<B5)))) How can I have the program calculate (B4-B3+(B4<B3)) AND IF B50 AND B6<=0 ADD "2:00" BUT IF B50 AND B60 ADD (B6-B5+(B6<B5)) TO (B4-B3+(B4<B3)) -- Thank You, God Speed, and Semper Fidelis |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show timesheet time in and out in regular time versus military tim | Excel Worksheet Functions | |||
Change to show time | Excel Discussion (Misc queries) | |||
subtraction of times, convert & multiply by a conditioned rate | Excel Worksheet Functions | |||
unmet challenge | Excel Worksheet Functions | |||
How to show negative time (e.g. -10 hours) | Excel Worksheet Functions |