Quote Originally Posted by Carim
Hi,

When I take the time 01:32 (hh:mm) and multiply it by 15 (Format "number" with 0 decimal places),

I get 23 if the result is formatted hh

Is that what you are looking for ?

HTH
Carim
Thanks that works ok but if you multiply by 17 (another activity) the result comes up as 02:04 in hh:mm format when it should be 23ish (sorry my maths is rubbish). So I think I need the result to be in number format. Any other ideas?