View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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.