Thread
:
convert time value of 14.58 to 2:35 pm
View Single Post
#
5
[email protected]
Posts: n/a
Have a look in the help at how Excel handles times and dates
=14.58/24 formated as time
will return
2:34 PM (note: I belive time does not round up in Excel)
HTH
RES
Reply With Quote