Posted to microsoft.public.excel.misc

Matt[_4_]

external usenet poster

Posts: 1

Time calculations

I'm trying to work out the formula to calculate time variances. I need to
display minutes as a number so it can be included in a CONCATENATE formula.
In addition to this, how do I calculate a sum such as 23:00 - 02:00? When
using a number, or general format in the result cell, excel doesn't return
the rersult I want. 180 (mins)

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 calculations	[email protected]	Excel Worksheet Functions	1	December 26th 08 10:15 AM
Time difference calculations, daylight savings time, Excel	Tim	Excel Discussion (Misc queries)	1	December 28th 06 04:18 PM
Overlapping time calculations and automatic time updates	Arlette	Excel Worksheet Functions	1	December 9th 06 12:20 AM
time calculations	lschuh	Excel Worksheet Functions	5	February 9th 06 09:12 PM
convert time imported as text to time format for calculations	batfish	Excel Worksheet Functions	3	October 27th 05 11:24 PM

All times are GMT +1. The time now is 09:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us