Convert Time values after midnight to 24:00, 25:00, 26:00

[2Plan]

I would like to run a query that changes the value "00:02" to "24:02" and "01:04" to "25:04"

These values have a text data type.

"00:02" represents 12:02AM
"01:04" represents 1:04AM

Thanks, for any assistance.

 

[snyperx3]

Hows this work?

Time: Cstr(Cint(Left([YourFieldName],2)) + 12) & Right([YourFieldName],3)



-Pete

 

[2Plan]

This code changes "00:12" to "12:12" instead of "24:12"
and "01:25" to "13:11" instead of "25:11

 

[snyperx3]

My apologies:

Time: Cstr(Cint(Left([YourFieldName],2)) + 24) & Right([YourFieldName],3)



-Pete