Results 1 to 5 of 5

Calculating Elapsed Time

Threaded View

  1. #1
    Registered User
    Join Date
    04-11-2008
    Posts
    2

    Calculating Elapsed Time

    I'm having trouble calculating elapsed time. I want the answer to state
    the number of days, hour, and minutes. In Column E I can get the number
    of hours but how do I parse this value to get Hours, days, minutes? I also need to divide the hours into days (ex. 1506/24)

    Thank you,

    A B C D E
    WO_No. REQ_DATE REQ_TIME WO_EST_START ElapTime
    1-20240274 1/9/2008 14:22:00 3/12/08 9:00 AM 1506:38:00
    1-20240688 1/14/2008 15:40:00 1/23/08 8:30 AM 208:50:00
    1-20240985 1/16/2008 13:57:00 2/7/08 4:30 PM 530:33:00

    Formula in E is =D2-(B2+C2).

    Thank you.
    Last edited by ExcelUser55; 04-11-2008 at 10:19 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1