Excel formula with multiple formulas per cell

[seantmcnamara]

i am trying to get a formula to work:
here is my issue

cell1: time value 10am
cell2: time value 2:00 pm
cell 3: total time 4 hours
cell 4: need to take cell 3 *$7.25
i tried basic cell 3*7.25 but because cell 3 is a value formula based on time it does not give me correct answer

I did this formula as recommended however my cell 4 now shows product of the formula even though there are no values??

[AlKey]

Try this formula in C1 format cell as Currency

Please Login or Register  to view this content.

Data Range

	A	B	C
1	10:00 AM	2:00 PM	$29.00

[JohnTopley]

Multiple Cell3 value by 24 =(B1-A1)*24 to get time in hours

[Pete_UK]

Don't quote your email address unless you want a load of spam.

Time values in Excel are stored as fractions of a 24-hour day, so 12 hours will be stored as 0.5, and 6 hours as 0.25, and so on. To get the correct answer, you thus have to multiply by 24, i.e.:

=(cell 3)*7.25 * 24

Hope this helps.

Pete

[seantmcnamara]

Thanks. However I still need cell 3 to show number of hours I need to create a cell 4 that has the dollar value of cell 3 *7.25

Thanks Much

[seantmcnamara]

Thanks Much.
I did this and it worked, however if there are no values to cell 3 (hours) it is giving me a value for the remainder of the formula and adding it to my column.
Any Suggestions

[AlKey]

in cell 3

Please Login or Register  to view this content.

format as General

in cell 4

Please Login or Register  to view this content.

Format as currency