Converting HH:MM:SS to decimal

[Brin_7]

Hi,

I've tried various formula to change HH:MM:SS to decimal but nothing is working and I really need to get the problem sorted soon.
I have 05:28:43 which needs to be converted to 5.5, I've tried USING INT, ROUNDDOWN and HOUR formulas but none are returning the correct value.

Can anyone please help me?

 

[pgc01]

Hi
Welcome to the board

The unit of data-time in Excel is the day.

With your time in A1, in B1:

=A1*24

format B1 as number

 

[Jameo]

Change the cell value to custom, and select hh:mm, then use the following forumla:

=INT(A2)*24+HOUR(A2)+ROUND(MINUTE(A2)/60,2)

Where A2 is your cell value. Should work.

If it is pumping out the wrong value, you may well have a date value in there also so have a check.

Looks like the above is a lot simpler, lol

 

[Brin_7]

Thank you both so much for you quick replies

I can now start to bulid my sheet