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

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

See the answers to your question in
news:microsoft.public.excel.worksheet.functions yesterday. Please don't
multipost.
--
David Biddulph


"doodle302" <(E-Mail Removed)> wrote in message
news:C6F7A0F2-D85E-4F02-B212-(E-Mail Removed)...
> 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