David,

I never noticed that until I saw your other post, I agree my solution is
unlikely to be the answer.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"David Biddulph" wrote:

That's fine if the contents of A2 and A1 are times formatted without the
colon, but they look as though they might be text.
--
David Biddulph


"Mike H" wrote in message
...
Hi,

Put this in A5 and format as general

=(A2-A1)*24
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Mario" wrote:


Can you please tell me what the formula for this is please.

A1 (start time) 0800
A2 (end time) 1515

A5 (total hrs=) 7.25

I need the formula for A5

TIA




.


.