LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default add duration to start time

how can i do this? eg. I start a job at 8am, I needed 2.8 hours to complete
the job, how do I add the [2.8 hrs] to [8am] to obtain an expected completion
time?

completion hour can show either in 12 or 24 hours time format.

thanks!
 
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
How do I add a duration time value and a clock time value? sueb262 Excel Worksheet Functions 3 July 16th 06 10:45 PM
Date/time Duration zjay Excel Worksheet Functions 1 May 24th 05 10:58 AM
Time duration formula Ska Excel Discussion (Misc queries) 2 February 18th 05 11:29 AM
Can't stop time duration [hh]:mm:ss converting to time of day Jack Cutrone Excel Discussion (Misc queries) 7 December 27th 04 11:23 PM
How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min o. Louis Excel Worksheet Functions 1 November 22nd 04 01:36 PM


All times are GMT +1. The time now is 03:09 PM.

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"