I am looking at invoices that have captured time spent on activity,
the system reports duration in hr min sec ( 5:47:06). I need to
convert this into a numbers that I can manipulate I could create a
formula such as = (5*3600) + (47*60) +06, however that is very manual
and I am looking at too many numbers. Is there something else I can
do? Thanks Shiftaw