Hi Guys,
Does anyone know how to format a field so can receive time 24:00 (12:00 pm).
Basically, I make a form that can receive time in and time out of heavy equipment.
For example time in = 19:00 and time out 24:00, and I have another field to calculate the duration between them. So duration should be = 24:00 - 19:00 = 5 hours.
However, what I found in the field appear 00:00 and it calculate as 12:00 am, so not 5 hours but 17 hours !!!
Thank you in advance
Budi
Does anyone know how to format a field so can receive time 24:00 (12:00 pm).
Basically, I make a form that can receive time in and time out of heavy equipment.
For example time in = 19:00 and time out 24:00, and I have another field to calculate the duration between them. So duration should be = 24:00 - 19:00 = 5 hours.
However, what I found in the field appear 00:00 and it calculate as 12:00 am, so not 5 hours but 17 hours !!!
Thank you in advance
Budi