calculateing

N

n1kk1

Hi, im having an absolute nightmare with this so any feedback would b
fantastic

I need to enter a formulae to calculate a column with hh:mm:s
(formatted for TIME) against a minute rate. So 00:00:30 at 20p a minut
would be 10p - help!

thn
 
H

hans bal(nl)

Use =HOUR(B1)*60+MINUTE(B1)+SECOND(B1)/60 to convert the time to a number of
minutes that you can multiply with yor rate.


HTH
 
Top