Convert Time Into A Number To Multiply By A Currency.

[tweak geek]

This is what I am trying to do: creating a spreadsheet to forcast a
employee work schedule, I am inputting the start time and finish time
totalling each position and totalling all the hours, so far so good
Now what I want to do is convert the total time into a number, done
only problem is the number only works as long as the hours do no
exceed 24 so how do I create a formula which will recognize the numbe
under 24 hours as is and recognized the number above 24?

example: for the total of 109:10 hours I am using the formul
=HOUR(B1)+(MINUTE(B1)/60) but I get the total 13.17 I am looking fo
the result to equal 109.17 or 109.166

The above formula works well with any time under 24 hours. please hel
as I am at my whits end. Thanx. T

 

[duane]

it looks to me like the problem is that you are calculating th
difference to be 109:10 hrs but excel is reading that as a date. Ca
you format that cell to be a number instead? The result will be 4.5
(days) and then you can directly calculate the hours

 

[Alan]

With 109:10 in B1 try in C1
=B1*24 and format C1 as General or Number with two decimal places,
Regards,