Thread: Convert time to number

Hello

I have a set of data conatining total number of hours & minutes spent of various activities. I need to convert these to calculate FTE (full time equivalent) headcount.
For example if time spent on an activity is 400 hours and a working year is 1600 hours then that shoudl convert to 0.25 FTE. Simple enough but seemingly not if the source data is in hours & minutes as follows: [h]:mm;[=0]"";General

The error I get, for example, is as follows:

Total time = 192:30 (in above format)
divided by 1600 hours should be 0.12
but calculates at 0.07

Any help would be much appreciated

thanks

Try multiply the time by 24 first...

e.g.

=A1*24/1600