Forum Discussion
Solved
How to convert clock times into hrs and minutes in Excel
Need to convert clock starting time minus clock ending time into decimal hours to calculate pay.
Example: 8:15 AM. 4:30 PM. = 8.25 Hrs. times Hour rate
If start time is in A1, end time in A2, then "=(A2-A1)*24" will give you a decimal number of the time spent. In my set-up, calculating with dates and times automatically displays a date/time format for the result With your example the result was "6:00 AM". Formatting as a number made it "8.25"
2 Replies
If start time is in A1, end time in A2, then "=(A2-A1)*24" will give you a decimal number of the time spent. In my set-up, calculating with dates and times automatically displays a date/time format for the result With your example the result was "6:00 AM". Formatting as a number made it "8.25"
- Thank you. That's exactly what I needed.
