Forum Discussion
Formula for putting overtime in seprate cell
Im new and trying to put in my husbands hours and having anything over 40hrs go into a separate cell so I can have it calculate his pay for OT. I have the cells that I put his hours in, a cell that c...
Hi Abeale!
To count your hours in one cell you have to change the cell formatting. Select the cell, take the shortcut CTRL 1 ( on alphanumeric keyboard, not on numeric block!) and now you’re on the formatting dialogue. There you can select date and time and search then for a format called „37:30:55“. This is the right format to show the hours beyond 24 hours. Click okay. Then take the sum function to sum up the different cells for your several hours.
Have a nice Weekend. Greets, Eva
To count your hours in one cell you have to change the cell formatting. Select the cell, take the shortcut CTRL 1 ( on alphanumeric keyboard, not on numeric block!) and now you’re on the formatting dialogue. There you can select date and time and search then for a format called „37:30:55“. This is the right format to show the hours beyond 24 hours. Click okay. Then take the sum function to sum up the different cells for your several hours.
Have a nice Weekend. Greets, Eva