S
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
the answer should be £56.38 but I get £2.35. Many thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
use
=A1*24*10.25
where A1< stores your time
use
=A1*24*10.25
where A1< stores your time
B
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)
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)
S
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
.