Results 1 to 11 of 11

Calculating Elapsed Time - but not overnight.

Threaded View

  1. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    If end time is in f11 and begin in e11 this formula should do

    =F11-E11-TIME(11;0;0)*value(trunc(f11)-trunc(e11))

    replace the ; with , if necessary
    Last edited by arthurbr; 04-13-2007 at 05:55 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