calculateing

[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

 

[Guest]

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