Posted to microsoft.public.excel.worksheet.functions

Atri

external usenet poster

Posts: 12

Calculate the difference between two times and show dd:hh:mm:s

thanks! It worked perfectly!

Is it possible to only calculate the time within 8 AM and 6 PM each day (in
stead of 24 hours)?
--
Atri

"Heera" wrote:

Hi,

Select the cell right click go the "Format Cell..."

Select Numbers Tab
Category : Custom and type the below mentioned line.

dd "Days"-hh:mm

Regards

Heera

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
Calculate the difference between two times - getting '#VALUE!' err	Louis de Pointe du Lac	Excel Worksheet Functions	2	June 20th 07 10:18 PM
calculate difference between two times	Ken	Excel Worksheet Functions	6	July 21st 06 09:05 PM
Calculate the difference between two times	Buffgirl71	Excel Worksheet Functions	3	February 10th 06 12:05 AM
Calculate the difference between two times	Buffgirl71	Excel Worksheet Functions	1	February 9th 06 10:10 PM
Calculate the difference two times	Chi	Excel Discussion (Misc queries)	2	July 16th 05 08:31 PM

All times are GMT +1. The time now is 07:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us