need to calculate time multiplied

S

scheins

i need to calculate a total time times by $4.00

for example the hours are 3:50 and i need it to be multiplied by 4

any help would be appreciated.

scheins
 
S

swatsp0p

You need to calculate your time as such:

(End time - Start time) multiplied by 24 then the result multiplied by
$4. format this cell as Currency.

Example:

A1 is the start time (13:00)
B1 is the end time (16:50)
C1 is the rate ($4.00)
D1 (formatted as Currency): =(B1-A1)*24*C1

This returns $15.33

good luck
 
N

Niek Otten

=A1/24*B1

Since time in Excel is stored as a fraction of a day

Kind regards,

Niek Otten
 
S

scheins

This is my set up
col a col b col c col d
Date Start End Total Hours
8-Sep 8:45 AM 12:30:00 3:50


i tried to rework your formula to what i have but it did not work
 
S

scheins

ok i got it to give me a number but it did not calculate correctly i
gave me only 15.00


sorry about the other post it just did not work before now and i jus
redid i
 
B

BenjieLop

scheins said:
This is my set up
col a col b col c col d
Date Start End Total Hours
8-Sep 8:45 AM 12:30:00 3:50


i tried to rework your formula to what i have but it did not work
Click to expand...


Your cells for "Start" and "End" must be time formatted for the formul
to work.

BTW, how can (12:30 - 8:45) be equal to 3:50? Shouldn't this be 3:45
 
Top