timesheet

  • Thread starter Thread starter Luc
  • Start date Start date
L

Luc

Hi all,

I've set up a timesheet and have different charge-out rates
for different people who have worked on a project. when i
put in a simple "rate" times "#hours" worked i get strange
results. i think it's to do with the formatting of the
cell that has the hours in it (formatted as hh:mm) and that
02:30 is not considered as 2.5 in decimal terms to multiply
it times the charge-out rate.

Does anyone know how i can get around this?

Thanks,

Luc
 
Thanks Frank, that worked great once again!

-----Original Message-----
Hi Luc
try
=rate*hours*24
and format the target cell as 'Number'

--
Regards
Frank Kabel
Frankfurt, Germany

.
Click to expand...
 
Back
Top