M
Mike McKenzie
Hello
I know how to display values as hours and minutes (you use
the colon) Excel can add values displayed in this way (eg
1:30 + 1:30 = 3:00) - but I need to multiply an
hours/minutes value by a general number -
Let's say I worked One and a half hours at £10 per hour
I want excel to give me...
1:30 * £10.00 = £15.00
Any suggestions
I know how to display values as hours and minutes (you use
the colon) Excel can add values displayed in this way (eg
1:30 + 1:30 = 3:00) - but I need to multiply an
hours/minutes value by a general number -
Let's say I worked One and a half hours at £10 per hour
I want excel to give me...
1:30 * £10.00 = £15.00
Any suggestions