I'm looking for a formula that will convert in/out times to total hours worked in a day. For example A1=7am, A2=11am, A3=11:30am and A4=4pm.
All of the times represent 1 work day. What formula will calculate those 4 numbers to show total hours worked or 8.5 hours in this case.
Thanks,
Chip
All of the times represent 1 work day. What formula will calculate those 4 numbers to show total hours worked or 8.5 hours in this case.
Thanks,
Chip