Posted to microsoft.public.excel.newusers

Israel

external usenet poster

Posts: 47

Subtract Time

Hi I have a column "A1" to "A300" with time data (06:19:21), how can I
subtract a half hour? The seconds should not be relevant in the final column.

Thank you
--
smile

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
Subtract hours from a time and get the correct time	casey	Excel Worksheet Functions	1	June 22nd 08 08:41 PM
how to increment time & subtract time?	Crackles McFarly	Excel Worksheet Functions	9	November 1st 07 10:10 PM
Add, subtract time	ab3d4u[_2_]	Excel Worksheet Functions	2	September 6th 07 04:56 AM
How do I subtract time?	Fletch74	Excel Worksheet Functions	3	August 19th 06 06:40 PM
how do I add/subtract time when I'm going from PM to AM (ex. 11:4.	tammyj	Excel Worksheet Functions	1	March 15th 05 07:31 PM

All times are GMT +1. The time now is 09:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us