Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 519

Time after midnight

Hello from Steved

This formula converts a number in to time =TEXT(D25,"0\:00")*1 ie 1530 15:30

My Question please the only way the formula will reconize 1210 am the next
day is to type 2410, I would like to type 10, what is require to the formula
above to acheive this. an example would be 15:30 to 24:10 as at the moment, I
would like to type in 15:30 to 0:10 to give a total hours as 08:40 ( after
midnight )

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
time around midnight	Mai-Britt	Excel Worksheet Functions	2	May 9th 07 01:05 PM
time clock wrap around midnight	BillO	Excel Worksheet Functions	3	April 30th 07 09:52 PM
subtraction off time after midnight	Steved	Excel Worksheet Functions	2	May 24th 06 01:46 AM
Calculating Time Past Midnight	Darren	Excel Worksheet Functions	6	March 13th 06 03:03 PM
Calculating time difference over midnight!	sygazelle	Excel Discussion (Misc queries)	4	September 29th 05 04:59 PM

All times are GMT +1. The time now is 08:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us