Menu

Subtracting two times in hh:mm:ss format

Search this Thread

#1

Report Post

Arvi Laanemets

Posts: n/a

Default

Hi

=Time2-Time1+(Time2<Time1)

Arvi Laanemets

"A Khan" <A wrote in message
...
I need to subtract two times that are in hh:mm:ss format and they occur on
different dates. Example:
Time 1:
03/22/2005 19:09:47
Time 2:
03/23/2005 01:02:51
Result = Time 2 - Time 1

I've tried different things but I keep getting #VALUE! in the result cell.
Any help would be appreciated.

Thanks.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Subtracting Times with Strang Format	carl	Excel Worksheet Functions	4	February 14th 05 07:55 PM
Subtracting times	[email protected]	Excel Discussion (Misc queries)	1	January 12th 05 09:55 AM
Subtracting Times	tvhazlett	Excel Worksheet Functions	1	November 29th 04 05:05 PM
Subtracting time in date format	Collcat	Excel Worksheet Functions	1	November 10th 04 09:40 PM
Subtracting time in date format	Collcat	Excel Worksheet Functions	1	November 10th 04 04:45 PM

All times are GMT +1. The time now is 04:48 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement