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.

Time after midnight
 

Time should be 15:30 and 00:10 then use formula =mod(b1-a1,1)

"Steved" wrote in message
...
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.

Time after midnight
 

Thankyou

"Mike G" wrote:

Time should be 15:30 and 00:10 then use formula =mod(b1-a1,1)

"Steved" wrote in message
...
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.