Time after midnight

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Time increment with additional condition of skipping weekends 13
subtraction off time after midnight 2
IF calculation of Time 2
Help with time interval 8
Access Access 2010 Time before and after midnight!!! 12
IF statement with time over midnight 3
airline standby worksheet 7
Calculate hours, past midnight etc 4

Top