Hours Conversion

B

Brent

I thought I would break up a previous post into some smaller questions to
see if I can put the answers together and have it work:). How is the best
way to convert a time reported like 13:50 is 1:30PM. I would like to get
it in the 1:30PM format so that I can use built in functions to calculate
time differences easier. Thanks
 
P

Per Larsen

Brent said:
I thought I would break up a previous post into some smaller questions to
see if I can put the answers together and have it work:). How is the best
way to convert a time reported like 13:50 is 1:30PM. I would like to get
it in the 1:30PM format so that I can use built in functions to calculate
time differences easier. Thanks
Click to expand...

format(time(), "hh:nn AM/PM")

hth PerL
 
Top