Forum Discussion
Shotzie154
Feb 27, 2019Copper Contributor
Excel formula help
I'm trying to create a time worked schedule for an employee. But I cannot figure out what type of formula to write to calculate how many hours were worked from the clock in time to the clock out tim...
Twifoo
Feb 27, 2019Silver Contributor
Assuming time in is in A1, time out in B1, and hours worked in C1, the formula in C1 would be:
=(B1-A1)*24
=(B1-A1)*24
SergeiBaklan
Feb 27, 2019Diamond Contributor
If that's not an overnight shift