mad cows disease?
 

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.

mad cows disease?
 

Try this:

=B1-A1+(A1B1)

Start time in A1, finish time in B1.

Hope this helps.

Pete

On Nov 14, 1:05 am, "Meebers" wrote:
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.

mad cows disease?
 

With the 11:00 in A1 and the 01:00 in B1
=(B1-A1)*24
Regards,
Alan.
"Meebers" wrote in message
...
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.

mad cows disease?
 

Pete....I owe you one....TX

"Pete_UK" wrote in message
ps.com...
Try this:

=B1-A1+(A1B1)

Start time in A1, finish time in B1.

Hope this helps.

Pete

On Nov 14, 1:05 am, "Meebers" wrote:
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.

mad cows disease?
 

Alan, whilst in the middle of beer #2....the answer I get is "-10" cell
formatted as "general", else I get #######
"Alan" wrote in message
...
With the 11:00 in A1 and the 01:00 in B1
=(B1-A1)*24
Regards,
Alan.
"Meebers" wrote in message
...
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.

mad cows disease?
 

Hi

Try
=MOD(B1-A1,1)
where B1 = finish, A1 = start

--
Regards
Roger Govier



"Meebers" wrote in message
...
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.

mad cows disease?
 

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.

"Roger Govier" <rogerattechnology4NOSPAMu.co.uk wrote in message
...
Hi

Try
=MOD(B1-A1,1)
where B1 = finish, A1 = start

--
Regards
Roger Govier



"Meebers" wrote in message
...
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.

mad cows disease?
 

You're welcome.

Pete

On Nov 14, 1:28 am, "Meebers" wrote:
Pete....I owe you one....TX

"Pete_UK" wrote in message

ps.com...



Try this:

=B1-A1+(A1B1)

Start time in A1, finish time in B1.

Hope this helps.

Pete

On Nov 14, 1:05 am, "Meebers" wrote:
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.- Hide quoted text -

- Show quoted text -