View Single Post
  #7   Report Post  
Niek Otten
 
Posts: n/a
Default

OFCOURSE that should have been

=A1*24*B1

!!

"Niek Otten" wrote in message
...
=A1/24*B1

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

Kind regards,

Niek Otten

"scheins" wrote in
message ...

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


--
scheins
------------------------------------------------------------------------
scheins's Profile:
http://www.excelforum.com/member.php...o&userid=27628
View this thread:
http://www.excelforum.com/showthread...hreadid=475077