I'm sorry, I don't know your name, but thank you... a TON... this actually
was more accurate in what I was trying to achieve. Since I work graveyard,
my hours bleed into the next day and try as I may, I could not get the hours
to reflect the way I needed them to. I am doing this to use as an auditing
tool so that I can audit the printouts I get back from my referral agency (I
work for myself).

Thanks so much... aaahhh... this was driving me crazy! :o)

Terrae

"JE McGimpsey" wrote in message
...
An alternative:

=MOD(E8-D8+G8-F8,1)*24

In article ,
"·!¦[··ï¡†¡ï·»Gen°Digger«·ï¡†¡ï··]¦!·" wrote:

Thank you for your reply... I understand the concept you are trying to
convey, but maybe if I give you the formula I currently have, you can
help
me figure out how to rework the formula to get it to do what I am trying
to
achieve:

=(E8<D8)+E8-D8+(G8<F8)+G8-F8

This formula is where I get 8:33 (in [h]:mm format) and where I would
like
to have the decimal format... can do?

Thank you... again... in advance for you kind assistance, I appreciate
it.