Posted to microsoft.public.excel.misc

external usenet poster

Posts: 164

Excel time calculation

I want to enter a time in c2 and I want d2 to show a time 50 minutes earlier.
What formula can I use. These time formulas have me baffled.
Note when I format the cell for time and enter 0700 the time returns as 00:00.

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
Excel 2003 Time Calculation	WR Cheng	Excel Worksheet Functions	1	June 28th 07 12:33 AM
time v cost calculation in Excel 2002 (XP)	matelodave	Excel Discussion (Misc queries)	4	December 10th 06 12:19 PM
How do I calculation time in excel in 24 hour method	Lloyd	Excel Discussion (Misc queries)	7	July 18th 05 08:43 AM
time calculation excel	Gate Keeper	Excel Worksheet Functions	1	December 31st 04 08:27 AM
Excel - Time calculation	Leyland	Excel Discussion (Misc queries)	1	November 30th 04 07:43 PM

All times are GMT +1. The time now is 11:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us