LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
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 11:19 AM
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 07:28 AM.

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

About Us

"It's about Microsoft Excel"