PDA

View Full Version : Number conversion to time

IanT
02-02-2004, 05:33 AM
Is it possible to convert a number ie 330 to a time varaible 05:30:00.

Thanks in advance
Mile-O
02-02-2004, 05:42 AM
=TimeSerial(Int([MyTime]/60), [MyTime] Mod 60, 0)