how do u turn time into a number
Why INT?
And if you reformat 3:45 to a number, wouldn't you want to multiply by 24 to
get it to decimal hours?
--
David Biddulph
"Jarek Kujawa" wrote in message
...
reformat 3:45 to number
and use the formula:
=INT(A1/2)*5
HIH
|