Thanks David,

So why does it work?
Never seen this one before.

Bill K
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
... or (somewhat shorter) =MOD(K1-J1,1)*24*60
--
David Biddulph

"Bill Kuunders" wrote in message
...

=IF(J1K1,(K1+1-J1)*24*60,(K1-J1)*24*60)

J1 is start time
K1 is end time

formatted as general

normally a general format time result gives you part of a day
thats why you have to multiply by 24 and 60 to get minutes
the "if" formula part will ensure you get the right result when times
fall
passed midnight


Bill K
Greetings from New Zealand


"Mcspore" wrote in message
...
I cannot, for the life of me, figure out how to make a cell read time in
total minutes. I am trying to read the amount of time elapsed in
minutes.
For example, I start running a sample at 18:32 (24 hour clock) and stops
at
21:43. I can get Excel to calculate the difference to 3:11 (3 hours and
11
mins) but I need it in terms of minutes (191 mins). I also cannot find
out
how to get excel to calculate time elapsed of any kind if it changes
days.
For example, if I start a sample at 22:32 and it ends at 01:43 (once
again
191 mins) excel gets confused.