Returning hour with a decimal
 

I have a cell that is showing total hours of my employee lets say 1:45 and I
want to know what the function I have to use to make that show 1.75.

Returning hour with a decimal
 

With your time in A1 and this formula as general try:-

=(A1-INT(A1))*24

Mike

"Jake Merrell" wrote:

I have a cell that is showing total hours of my employee lets say 1:45 and I
want to know what the function I have to use to make that show 1.75.

Returning hour with a decimal
 

Multiply the cell with 1:45 by 24. Then format as General. So, if A1=1:45,
B1=A1*24. Format B1 as General.


--
Hope that helps.

Vergel Adriano


"Jake Merrell" wrote:

I have a cell that is showing total hours of my employee lets say 1:45 and I
want to know what the function I have to use to make that show 1.75.