dtencza

Posts: n/a

Time calculation (in hh.mm) spanning more than one day

I would like to calculate the difference between two dates and times and have
the result be in hh.mm.

So if in Cell A1 I have '8/15/2005 9:30 AM'
and if in Cell A2 I have '8/16/2005 11:17 AM' then...

I would want the result in Cell A3 to be 26:01.

Can anyone tell me what formula I would use to do this? My boss asked me
just a few minutes ago!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 calculation with military time	Ron Thetford	Excel Worksheet Functions	8	July 29th 05 07:24 PM
Time Calculation in Minutes only ?	pgcam	Excel Worksheet Functions	1	May 20th 05 04:46 PM
Time Sheet Calculation Help Needed!	sax30	Excel Worksheet Functions	2	April 26th 05 08:08 PM
Time Calculation	chintu49	Excel Worksheet Functions	2	February 16th 05 02:55 PM
elapsed time calculation	rwf	Excel Discussion (Misc queries)	1	January 21st 05 04:51 AM

All times are GMT +1. The time now is 10:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us