Hi
if this really is a time formatted cell - then the
contents are already a number, just formated to show
time. In Excel (and lots of other places) 1 = 1 day so
1/24 is = 1 hour. So you should be able to simply divide
your value by 24 then multiply by hourly rate.
ttfn benm
|