Assuming your time input cells are formatted correctly ( I would use 24 hour time for clarity: e.g. 17:00 vs. 5:00 pm but it's your choice).
This formula will calculate the hours worked:
=(B13-B12)*24
Assuming your time input cells are formatted correctly ( I would use 24 hour time for clarity: e.g. 17:00 vs. 5:00 pm but it's your choice).
This formula will calculate the hours worked:
=(B13-B12)*24
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks