LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Art Art is offline
external usenet poster
 
Posts: 587
Default Elapsed Time Formula

A1 22:23:54 Start Time
A2 02:15:30 End Time
A3 3:52 Elapsed Time (Hrs:Min)

I need the formula that would produce the result shown in cell A3.
(A3 is formatted in hr:mm).

Though no dates are shown, total elapsed time will never exceed about 6 hours.

Thank you .

--
Art
 
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
formula to add time elapsed twills44 Excel Worksheet Functions 1 June 11th 08 05:45 AM
Formula for elapsed time + grand total Leland7 Excel Discussion (Misc queries) 8 August 8th 07 11:14 PM
time elapsed formula sue Excel Worksheet Functions 3 February 3rd 06 02:04 AM
Ref: Formula to calculate elapsed time between certain dates and t DrBarqs Excel Discussion (Misc queries) 2 November 18th 05 11:16 PM
Formula to calculate elapsed time between certain dates and times Stadinx Excel Discussion (Misc queries) 6 March 25th 05 07:02 AM


All times are GMT +1. The time now is 03:55 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"