Time period spanning midnight
David,
I shall completely understand if you do not want to be bothered to
explain and ignore this further message of mine but I did look at Excel
help where I find
"MOD(number,divisor)
Returns the remainder after number is divided by divisor. The result has
the same sign as divisor."
Hence my puzzlement and my inquiry.
Stephen
In article , David Biddulph
<groups@[at] writes
Why not look in Excel help to see what the MOD function does?
--
David Biddulph
"Stephen White" wrote in message
...
Many thanks. This is very neat and works so far as I have tested it so
long as I make it
=MOD(B1-A1,1)*24
But can you please explain to me why it works? Why does it not always
give a result of zero since the modulus of anything divided by 1 must be
zero, musn't it and anything multiplied by zero is zero?
In article , T. Valko
writes
Enter the times as TIMES
A1 = 21:30
B1 = 3:45
What is the neatest formula to calculate the number
of hours between them?
=MOD(B1-A1,1)
--
Stephen White )
--
Stephen White )
|