| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
