I am trying to put together a basic spreadsheet to track temp staff hours. the problem i am having is when i try and auto calculate the difference between start and finish times minus breaks it can not display the total hours worked for the day because excel keeps trying to display the time in specific days/hours/mins/secs instead of general 24hour times. EG.
Start Finish Break Total hours worked
Tuesday 9:30 16:30 45mins
Wednesday 9:30 16:30 55mins
Thursday 9:30 16:30 20mins
Friday 9:30 16:30 0
Monday 9:30 16:30 0
I tried formatting the cell as 24hour time but it still takes it as a specific date/time.
Much appreciated if anyone could assist me.
Kind regards
Start Finish Break Total hours worked
Tuesday 9:30 16:30 45mins
Wednesday 9:30 16:30 55mins
Thursday 9:30 16:30 20mins
Friday 9:30 16:30 0
Monday 9:30 16:30 0
I tried formatting the cell as 24hour time but it still takes it as a specific date/time.
Much appreciated if anyone could assist me.
Kind regards