Time Number Format
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.
|