Hi, im having an absolute nightmare with this so any feedback would be fantastic
I need to enter a formulae to calculate a column with hh:mm:ss (formatted for TIME) against a minute rate. So 00:00:30 at 20p a minute would be 10p - help!
thnx
Hi, im having an absolute nightmare with this so any feedback would be fantastic
I need to enter a formulae to calculate a column with hh:mm:ss (formatted for TIME) against a minute rate. So 00:00:30 at 20p a minute would be 10p - help!
thnx
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
"n1kk1" wrote:
>
> Hi, im having an absolute nightmare with this so any feedback would be
> fantastic
>
> I need to enter a formulae to calculate a column with hh:mm:ss
> (formatted for TIME) against a minute rate. So 00:00:30 at 20p a minute
> would be 10p - help!
>
> thnx
>
>
> --
> n1kk1
> ------------------------------------------------------------------------
> n1kk1's Profile: http://www.excelforum.com/member.php...o&userid=35173
> View this thread: http://www.excelforum.com/showthread...hreadid=549393
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks