convert "37:30:55" to decimal

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

Multiply with 24 and format as general or number not time

--

Regards,

Peo Sjoblom

"Teaman" <Teaman@discussions.microsoft.com> wrote in message
news:0C58BEB5-2EF3-4FAD-ABB9-27B82FF3DC9A@microsoft.com...
> 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

Try multiplying by 24 and formatting the result as General.

=a1*24

If A1 contained 113:30:00.

Teaman wrote:
>
> 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

--

Dave Peterson