=A1*24*B1
assuming that A1 is time format, and B1 is the rate
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Ska" wrote in message
...
How can i return the result from a cell contaning hour and minutes
multiplied
by a cost per minute or hour ie 2hr 30mins multiplied by £7 per hour = ?
Ta
Stuart
|