Hi All,

I've been stuck on an excel extraction I ran through a rostering software.

Basically it pulled

1.00:00:00
1.12:00:00

Day.HH:MM:SS

However when trying to convert it to just hours using numerous different formulas I'm getting name or value errors.

Do I need format the column first before trying to convert it to hours in the blank cell?

I'm stuck on both the formatting of the cell and the formula to convert to hours.

Very frustrating