mad cows disease?

M

Meebers

Brain fade....trying to find time elapse from 11:00pm to 01:00 am the next
day to get 2:00. Can't recall the function to do this in addition to the
simple subraction. So far...one cold beer did not help.
 
P

Pete_UK

Try this:

=B1-A1+(A1>B1)

Start time in A1, finish time in B1.

Hope this helps.

Pete
 
M

Meebers

Alan, whilst in the middle of beer #2....the answer I get is "-10" cell
formatted as "general", else I get #######
 
M

Meebers

TX Roger, I thought it was MOD, however after reading the description of it
"Returns the remainder after a number is divided by a divisor" so I blew it
off. I guess division is a form of subtraction though.
 
Top