hi,

I have a cell (G11) whose format is [h]:mm to store hours worked in a week.
I need to use that in a VBA function. If I query G11.value I get a
non-integer number (I DO know that Excel stores time internall like that).
How can I get in a VBA procedure exactly what is see in the cell..e.g if
someone worked 35:15 hours, I want to be able to get 35:15 in the procedure.
I need to strip it from there to work out payment, eg (hourly rate * 35) +
(hourly rate * (15/60)/100).

I have tried using format but it does not like the "[h].mm" argument.

any help is much appreciated.

Chris