Thanks to all who responded - I have been out on vacation and actually
figured this out before I left. KL is absolutely correct in that I just
needed to multiply the time value by 24 to receive the correct result. You
were all very kind to respond.
Kind Regards,
numberman37

"KL" wrote:

Hi numberman37,

I am not sure I understand you. For Excel 2:42=0.1125, pretty much like
11%=0.11. Why would you need to use the look of the value and not the value
itself. I think it just takes to understand that Excel uses integers for
dates (number of days since 1-1-1900) and decimals between 0 and 1 for time
where 0&1=24:00, 0.0416666666666667=01:00, 0.5=12:00, etc. If you want a
decimal representation of time in hours you could multiply the time value by
24, e.g. 0.1125*24=2.7=2 h 42 min.

Hope this helps.
KL


"numberman37" wrote in message
...
When subtracting two dates/times from each other, Excel stores the result
as
a number different from the displayed result (e.g., displayed result =
2.42
hours but stored number = 0.1125.) How can I effectively use the
displayed
result in a subsequent formula rather than the stored number?