Posted to microsoft.public.excel.misc

external usenet poster

Posts: 168

Minus time

Thank you very much.

"Mike" wrote:

enter in B1
=A1 - TIME(1,0,0)

"Tufail" wrote:

hi,
i have in cell A1 current time and in cell B1 i want show minus 1hr from
current time so plz someone help me, thanks in advance.

A1 (C-Time) B1
16:00 15:00

Reply With Quote

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
How do I input a minus time in an excel spreadsheet	Nadine NZ	Excel Worksheet Functions	1	May 11th 06 11:46 PM
Hot key for time?	Dave in Des Moines	New Users to Excel	2	March 24th 06 04:31 PM
Hot key for time?	Dave in Des Moines	Excel Worksheet Functions	2	March 24th 06 04:15 PM
Hot key for time?	Dave in Des Moines	Excel Discussion (Misc queries)	1	March 24th 06 03:46 PM
I need to add and subtract time cells. ie. 13:45 minus 13:58	Mschertz	Excel Discussion (Misc queries)	1	October 21st 05 06:30 PM

All times are GMT +1. The time now is 08:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us