Posted to microsoft.public.excel.misc

P Vasanth Kumar P Vasanth Kumar is offline

external usenet poster

Posts: 5

how to minus the time value

How to minus the value of time format value. Ex: Now 12:00 Pm we want to had
that cell to cell 5 mins(like 12.05, 12.10, etc.,)
Please give me solution for this.

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 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 10:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us