Forum Discussion
Format problem calculating salary
I want to calculate salary. I enter hours 'from' and 'to' using Format Time: 13:30. Then I add the days in a cell using Format Custom: [h:mm]. I add the four weeks using the format Custom: [h}:mm. So...
You’ve got it — the key is that Excel stores time as fractions of a day.
So 10:15 means 10 hours and 15 minutes, which is actually 10.25 hours if you multiply by 24.
So for your workflow:
- Use your [h]:mm format to enter & sum hours across days.
- Then in a separate cell, convert total time to decimal hours:
Now you can safely divide by 20 and multiply by your hourly rate. Example:
If YourTotalCell was 119:45, then 119.75 (in decimal) will come automatically.