Hi all,
O k so I have a sheet with quite a bit of code in, the bit i am stuck on is: in certain cells there are time values i.e. 00:00:00, hh:mm:ss and I somehow need to add these times together so, 00:30:00 + 00:30:00 would equal 1 hour. I need to convert this into a decimal as i am also multiplying this (1 hour) by a number (qty) and another number (hourly rate) to give me a cost. Ive added the code im using below.


Please Login or Register  to view this content.
The setup and runtimeea are the parts that throw the errors, for some reason its grabbing these values (which are on the sheet 02:22:00) as 0.1 or something along those lines, I need the time value on the sheet to be recorded in the macro as a decimal i.e 02:30:00 would be 2.5.

Thanks in advance for any help

Pete