Number to time conversion over 24hrs

[IanT]

Hi

Is it possible to convert 2220 to time ie 37:00:00!

The code below converts upto 24:00 but after this it shows a date!

=TimeSerial(Int([MyTime]/60), [MyTime] Mod 60, 0)

Thanks in advance..............

 

[Mile-O]

This gets asked on an almost weekly basis now - do a search as it's been answered on a weekly basis too.

Also, was there something wrong with this (re: the conversion)?

Previous Question

 

[IanT]

Hi

The string works ok when the value is =<1440, above this the value returned is ie 31/12/1899 04:00:00.

 

[Mile-O]

You won't be able to return a value over 23:59:59 in a date/time field.

You can use a function to convert to a number of hours that is 24 or greater as this is usually just for display purposes.

Here's one of the better threads on the subject.