John_Franco John_Franco is offline

Junior Member

Location: Quito

Posts: 2

Send a message via Skype™ to John_Franco

Quote:

Originally Posted by John_Franco

Just subtract, use -

Forget the date format, Excel dates are sequential numbers

Your result will be 2.326388889

What does this mean?

You have 2 days and 0.326388889 time

Convert 0.326388889 to time format 37:30:55 for example and done

Learn more about excel dates, visit: http://www.excel-spreadsheet-authors...xcel-date.html

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
How do I set my time and get rid of sample time using functions	NapierGye	Excel Worksheet Functions	4	April 4th 09 10:10 PM
Calculating time without using time functions...	Ian R	Excel Worksheet Functions	4	August 26th 07 02:08 PM
Time between days	RamOst	Excel Worksheet Functions	7	May 11th 06 03:28 PM
Calculating days & time left from start date/time to end date/time	marie	Excel Worksheet Functions	7	December 7th 05 02:36 PM
date functions for previous 60/90/180 days	BBranch	Excel Worksheet Functions	2	September 2nd 05 05:31 PM

All times are GMT +1. The time now is 05:56 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us