Posted to microsoft.public.excel.newusers

teezee

Posts: n/a

formula to subtract time, 12:10 am (00:10) - 11:50 pm (23:10) ?

Posted to microsoft.public.excel.newusers

Roger Govier

Posts: n/a

formula to subtract time, 12:10 am (00:10) - 11:50 pm (23:10) ?

Hi

One way
With 00:10 in A1 and 23:50 in B1
=MOD(A1-B1,1)

--
Regards

Roger Govier

"teezee" wrote in message
...

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to 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
Formula is entering a default time when it comes across an empty cell..	Howie	Excel Worksheet Functions	10	November 16th 05 11:34 AM
How can I correct this Time formula	John	Excel Worksheet Functions	11	November 4th 05 03:57 PM
Formula for a time card	skateblade	Excel Worksheet Functions	6	November 2nd 05 09:28 PM
Excel formula for a time sheet	HRMSN	Excel Worksheet Functions	1	August 10th 05 03:07 PM
Time / Formula to look at time difference	carl	Excel Worksheet Functions	5	November 8th 04 06:59 PM

All times are GMT +1. The time now is 05:47 AM.

About Us

"It's about Microsoft Excel"