multiply hours and £

[Sam]

Can anyone tell me how i could multiply 05:30 * £10.25
the answer should be £56.38 but I get £2.35. Many thanks

 

[Frank Kabel]

Hi
use
=A1*24*10.25
where A1< stores your time

 

[Bob Phillips]

Sam,

The reason for Frank's solution is that time is stored as a fraction of 1
day. For instance, 8 hours is stored as .3333. That is why you need to
multiply by 24 to get the decimal hours.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Sam]

Many thanks much appreciated Frank

-----Original Message-----
Hi
use
=A1*24*10.25
where A1< stores your time

--
Regards
Frank Kabel
Frankfurt, Germany

thanks

.