Changing time format
In order to multiply 'Time' by 'Currency' - you should ad a multiplication by
24 as well in the formula and format that(!) cell as 'Currency'.
Micky
"doodle302" wrote:
I'm trying to chage the time format so they can be multiplied by a number
Example: ( 6:30 - 2:45 - 1:30 - 2:15 ) * 3 = total amount due in dollars
The four time are for different days
Thanks for any ideas
|