Thread: Converting minutes to hours and calculating pay

Hey Guys,

I just want to know the formula for how to convert minutes into hours and calculate the pay on $20 an hour e.g.

2 columns

one is the date worked and how many minutes like this e.g.
Date minutes
2/07/10 45
3/07/10 60
4/0710 20

total minutes a sum (the sum button)
total hours formula to convert minutes to hours

total pay say they get $20 an hour (calculate the pay on $20 an hour)

Thanks in Advance
Andre

Normally time is entered as 00:45. Excel will convert this into a value between 0 which is 00:00 and 1 which is 24:00.

So please enter time values like that OR devide by 60

in your case =20*sum(B1:B3)/60

entering time values would make your formula: =20*24*SUM(B1:B3)