Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kathy
 
Posts: n/a
Default convert military time to regular hours

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default convert military time to regular hours

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
FormatCellsCustom 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

--
Regards

Roger Govier


"Kathy" <Kathy @discussions.microsoft.com wrote in message
...
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time sheets Driver Excel Worksheet Functions 5 November 7th 05 12:19 PM
convert interval to various separate date , time, hr, minutes Todd F. Excel Worksheet Functions 4 July 12th 05 07:25 PM
Figuring military time for total hours David Nelms Excel Worksheet Functions 3 July 5th 05 05:00 PM
Convert decimal hour into time format? ramdalen Excel Discussion (Misc queries) 2 June 20th 05 06:21 PM
comparing a value in a cell to see if it is higher than a number PK Excel Worksheet Functions 9 June 2nd 05 03:35 PM


All times are GMT +1. The time now is 11:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"