convert military time to regular hours

G

Guest

I would like to covert military time to regular hours - (i.e 1.50 hrs to 1
hour 30 minutes) and also keep track of the average time it takes to finish a
task -

(i.e.
1 task could take 1.25 or
1 task could take 2.50 hours

I would like to be able to show "on average" how long it takes a task to be
completed.

Thanks,
Kathy
 
R

Roger Govier

Hi Kathy

Excel stores times as fractions of a day (24 hours). So to convert your
1.5 hours to 1:30, divide by 24 and
Format>Cells>Custom> hh:mm:ss

To get the average with 1:15 in B1 and 2:30 in B2 simply enter
=AVERAGE(B1:B2) to return 1:52:30
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

military time set up 6
Adding/Subtracting military time 0
Show timesheet time in and out in regular time versus military tim 1
Convert Number in to Hours.... 3
How do I convert Military Time to minutes? 1
Calculating regular time, subtracting any personal time 5
Decimal to Time Format. 5
convert length of time to minutes from hundreths 2

Top