Posted to microsoft.public.excel.worksheet.functions

Steved

external usenet poster

Posts: 519

After midnight

Hello from Steve Dee

What is required to the below to go past midnight.

=F20+TIME(0,32,0)

Thankyou

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
Midnight will not display in cell	·!¦[··ï¡?¡ï·»Gen°Digger«·ï¡?¡ï··]¦!·	Excel Worksheet Functions	3	October 23rd 07 11:03 AM
Time after midnight	Steved	Excel Worksheet Functions	2	May 30th 07 08:10 PM
time around midnight	Mai-Britt	Excel Worksheet Functions	2	May 9th 07 01:05 PM
mod formula used with midnight	S in AZ	Excel Worksheet Functions	1	September 6th 06 09:31 PM
subtraction off time after midnight	Steved	Excel Worksheet Functions	2	May 24th 06 01:46 AM

All times are GMT +1. The time now is 12:03 AM.

About Us

"It's about Microsoft Excel"