=INT((TIME(INT(A1),MOD(A1,1)*100,0)-TIME(INT(A2),MOD(A2,1)*100,0))*24)+
(MOD((TIME(INT(A1),MOD(A1,1)*100,0)-TIME(INT(A2),MOD(A2,1)*100,0))*24,1)*60/100)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Clekn" wrote in message
...
I have to take a decimal like 22.59 which is already in hr.mm (22 hrs 59
min)
and be able to add and subtract values for a cumulative total in hr.mm
format. This seems too simple but for some reason when I apply previous
suggestions I've found in earlier posts it keeps giving me a VALUE error.
Any
suggestions?