View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default convert "37:30:55" to decimal

Multiply with 24 and format as general or number not time

--

Regards,

Peo Sjoblom

"Teaman" wrote in message
...
I have a field that is formated as time format 37:30:55. I would like to
conver this value to decimal value. for example: 113:30:00, I would like

to
read it as 113.5. How do I do that?
Thanks,
Sam