hours X rate

dmont · May 19th, 2002, 02:48 PM

I have a simple spreadsheet that has project start time(Formatted for time(hh:mm)) in cell A1, project end time (Formatted for time (hh:mm)) in cell B1, a simple formula to calculate time on project (formatted for time (=b1-A1)) in cell C1, rate of pay (formatted for currency) in D1. I need a formula and format for cell E1 to calculate Project Cost (=C1*D1) gives an incorrect answer when E1 is formatted for currency and obviously I get an incorrect formatt when formatted for time.

Aladin Akyurek · May 19th, 2002, 02:59 PM

Quote:

On 2002-05-19 13:48, dmont wrote:
I have a simple spreadsheet that has project start time(Formatted for time(hh:mm)) in cell A1, project end time (Formatted for time (hh:mm)) in cell B1, a simple formula to calculate time on project (formatted for time (=b1-A1)) in cell C1, rate of pay (formatted for currency) in D1. I need a formula and format for cell E1 to calculate Project Cost (=C1*D1) gives an incorrect answer when E1 is formatted for currency and obviously I get an incorrect formatt when formatted for time.

=C1*D1*24

dmont · May 19th, 2002, 03:05 PM

Thank you Aladin it works like a charm. I didn't think about the 24!!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 19th, 2002, 02:48 PM	#1
dmont New Member Join Date: May 2002 Location: Indiana Posts: 2	I have a simple spreadsheet that has project start time(Formatted for time(hh:mm)) in cell A1, project end time (Formatted for time (hh:mm)) in cell B1, a simple formula to calculate time on project (formatted for time (=b1-A1)) in cell C1, rate of pay (formatted for currency) in D1. I need a formula and format for cell E1 to calculate Project Cost (=C1*D1) gives an incorrect answer when E1 is formatted for currency and obviously I get an incorrect formatt when formatted for time.

May 19th, 2002, 03:05 PM	#3
dmont New Member Join Date: May 2002 Location: Indiana Posts: 2	Thank you Aladin it works like a charm. I didn't think about the 24!!!!