Im trying to set up a timesheet for someone on a spreadsheet so that they can enter their start and finish times and it calculates the hours worked. totals them and multiplies his rate to total it all up and displays all the data.

The problem is that if I have the enter the start and finish times as actual times (i.e 5:00am) and format the cell as a time so that it displays the info clearly, it totals the hours up based on the calender (I think) instead of a quantity so the calcs dont flow on.

Is there a way that I can change this? I want to be able to display the times correctly but also calculate them.

TIA

 

Type in time using "Time" "Space" "A" or "P". <- make sure cell is in Custom Format (H:MM AM/PM)
Find total hours by (Out-In)*24 <- make sure cell is in Numbers Format

You should be able to total the hours then.

 

Awesome I knew I should have looked at the exact significance of the hours decimal to see if there was a direct function!

 

If you need more help feel free to PM me Excel is my specialty