Posts: n/a

time subtraction problem

I have two times,
22:19 pm and 1:50 am
obviously 1:50 is after 22:19 but when I try to subtract it -- 22:19 - 1:50
excel gives me gibberish.

thnks.

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
LOCK TIME	confused	Excel Discussion (Misc queries)	4	May 23rd 05 08:34 PM
Time Sheets	Lady Layla	Excel Discussion (Misc queries)	1	March 23rd 05 03:22 PM
subtraction with time format cells	Stefano	Excel Worksheet Functions	2	March 17th 05 03:06 PM
Help - Information with time and date	PM	Excel Discussion (Misc queries)	4	January 6th 05 08:25 AM
Problem with time calc	Tom	Excel Worksheet Functions	2	November 6th 04 12:04 PM

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

About Us

"It's about Microsoft Excel"