Hi all,

Not sure if this is possible, I cannot find anything across the net that matches what i neeed as yet. Would be grateful if anyone can help?

I have a log of holidays - this is for full time and part time workers. For the full time workers we simply log a 'h' for holidays. For the part timers, the log was developed by someone else (not me) to have to enter 'hh' and the number of hours i.e. 'hh4.5'. There was then a second row which used '=left(....' to pull through the number, and sum up at the end.

I want to remove the need for this second row on part-time as it causes lots of formula problems, as well as formatting.

Does anyone know how I can sum the numbers in these cells? I have played with SUMIF, but dont how to incorporate the "if it starts with 'hh' then sum the number after 'hh'"....

Capture.JPG

Many thanks in advance
Ashleigh