Hello,
I am a workforce analyst, and needs to know how many hours of lates, time
off, OT's, etc..we have...so I created a worksheet.

I exported the entered Hours from our database but unfortunately it is in
General Format and seems to be locked. When multiplying it to 24 to convert,
it gives #VALUE error data is of different type. I tried the TIMEVALUE
function to unlock but it does not show the correct number of hours if it
goes beyond 24.

Example: Total OT hours is 31 hours (31:00 display from exported database),
the format is General and it can't be changed...I used the TIMEVALUE function
to "unlock" then multiplied it by 24, it gives 7 Hours only when changed to
number format, I realized it lacks 24 hours so I used the [h]:mm (bracket)
format but still does not include all hours.

I don't have issue if the collected hours is lower than 24 hours.
Example, collected hours is 6:30 using TIMEVALUE and multiply by 24 gives
6.5 hours in number format this is good but when collected hours goes beyond
24, ther goes the problem.

Ultimately what I want to see is...
Example: Collected Hours is 435:15 (display from exported database, in
General "locked" format)

Result should be 435.25 hours

Your help is greatly appreciated.

Thanks!