| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Between time
HI, If any one could help with this i would be greatful. I have thetime time in a1 starting at 08:00 and going down the pagein 15 mintue intervals, in the next column i have a number next to the time. I would like a formula to be able to read and display the second column number depending on the time stated in cell c1 in d1. any help would be great. thanks brent -- Brento ------------------------------------------------------------------------ Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213 View this thread: http://www.excelforum.com/showthread...hreadid=567674 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Between time
In D1 =LOOKUP(C1,A1:B64) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=567674 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Between time
Hi Sandy, You're right, you really need to input the times manually, see here http://support.microsoft.com/kb/211830/en-us -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=567674 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Between time
Thank you Daddylonglegs,
I tried precision as displayed as the article suggests but it failed to correct the problem for me whether applied before or after the data/formula. It's not very elegant but I found that: =CEILING(A1+TIME(0,15,0),TIME(0,15,0)) seemed to correct the problem then of course you could copy/paste special values Just thinking about creating a large number of progressive usable times -- Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "daddylonglegs" wrote in message news:daddylonglegs.2bzh0j_1154640959.0549@excelfor um-nospam.com... Hi Sandy, You're right, you really need to input the times manually, see here http://support.microsoft.com/kb/211830/en-us -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=567674 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Between time
For the archives, if for no other reason, I tried the *precision as
displayed* on XL 2002 at work and it corrected the return form the function. (But then you all new that would didn't you <g) However, there are many times when you would not want to have that option selected. -- Regards, Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "Sandy Mann" wrote in message ... Thank you Daddylonglegs, I tried precision as displayed as the article suggests but it failed to correct the problem for me whether applied before or after the data/formula. It's not very elegant but I found that: =CEILING(A1+TIME(0,15,0),TIME(0,15,0)) seemed to correct the problem then of course you could copy/paste special values Just thinking about creating a large number of progressive usable times -- Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "daddylonglegs" wrote in message news:daddylonglegs.2bzh0j_1154640959.0549@excelfor um-nospam.com... Hi Sandy, You're right, you really need to input the times manually, see here http://support.microsoft.com/kb/211830/en-us -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=567674 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Between time
Sandy,
the Microsoft article did not refer to XL97. One could take that to mean that it is not affected by this "feature", or that the correction does not work in XL97 (or that it's a bit old so we're not bothered anyway...) Pete Sandy Mann wrote: For the archives, if for no other reason, I tried the *precision as displayed* on XL 2002 at work and it corrected the return form the function. (But then you all new that would didn't you <g) However, there are many times when you would not want to have that option selected. -- Regards, Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "Sandy Mann" wrote in message ... Thank you Daddylonglegs, I tried precision as displayed as the article suggests but it failed to correct the problem for me whether applied before or after the data/formula. It's not very elegant but I found that: =CEILING(A1+TIME(0,15,0),TIME(0,15,0)) seemed to correct the problem then of course you could copy/paste special values Just thinking about creating a large number of progressive usable times -- Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "daddylonglegs" wrote in message news:daddylonglegs.2bzh0j_1154640959.0549@excelfor um-nospam.com... Hi Sandy, You're right, you really need to input the times manually, see here http://support.microsoft.com/kb/211830/en-us -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=567674 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
| formula to determine time range overlap? | Excel Discussion (Misc queries) | |||
| Hot key for time? | Excel Worksheet Functions | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Entering Times | Excel Discussion (Misc queries) | |||
Hybrid Mode
