Changing time format

D

doodle302

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Someone knows how to add hyperlinks to hours to schedule an appointment? 0
Help with time formats in Excel 2007, 0
How can the font and size of (all) citation numbers be altered? 1
How to change font & size of (all) citation numbers? 7
Linking Child Timelines to Multiple Parents 0
convert time to decimal 2
adding hours and minutes 7
Numaric to Inword in excel by VB 1

Top