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