slimshades26
Technical User
CR8.5
Looking to put the AS400 numeric data field {F55ALLOC.S5TDAY} to standard 24 hour:
191832 = 19:18:32
249 = 00:02:49
22713 = 02:27:13
Among other tries the following formulas and undesired results:
ISTIME() formula gives me "true"
CTIME() formula gives me "0:00:00" for every record.
TIME() formula gives me "0:00:00" for every record.
Thanks for any response. ss26
Looking to put the AS400 numeric data field {F55ALLOC.S5TDAY} to standard 24 hour:
191832 = 19:18:32
249 = 00:02:49
22713 = 02:27:13
Among other tries the following formulas and undesired results:
ISTIME() formula gives me "true"
CTIME() formula gives me "0:00:00" for every record.
TIME() formula gives me "0:00:00" for every record.
Thanks for any response. ss26