How do I convert time (38:30) to decimal (38.5) format?
 

How do I convert time (38:30) to decimal (38.5) format?

How do I convert time (38:30) to decimal (38.5) format?
 

In a cell that's formated as number, 2 decimals, put: =B1*24
Where B1 contains your 38:30.
************
Anne Troy
www.OfficeArticles.com

"Lori" wrote in message
...
How do I convert time (38:30) to decimal (38.5) format?

How do I convert time (38:30) to decimal (38.5) format?
 

Multiply with 24 AND format as general or number

--
Regards,

Peo Sjoblom

(No private emails please)


"Lori" wrote in message
...
How do I convert time (38:30) to decimal (38.5) format?

How do I convert time (38:30) to decimal (38.5) format?
 

Thank You!

"Anne Troy" wrote:

In a cell that's formated as number, 2 decimals, put: =B1*24
Where B1 contains your 38:30.
************
Anne Troy
www.OfficeArticles.com

"Lori" wrote in message
...
How do I convert time (38:30) to decimal (38.5) format?

How do I convert time (38:30) to decimal (38.5) format?
 

Welcome! :)
************
Anne Troy
www.OfficeArticles.com

"Lori" wrote in message
...
Thank You!

"Anne Troy" wrote:

In a cell that's formated as number, 2 decimals, put: =B1*24
Where B1 contains your 38:30.
************
Anne Troy
www.OfficeArticles.com

"Lori" wrote in message
...
How do I convert time (38:30) to decimal (38.5) format?