Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variables with times between Midnight and 1:30am
I have an interesting problem, I am writing a function where there are
a few hard coded times for the function to use. I am however having problems applying a variable value to 1:00 AM. Here is my code for the variable application ThirdStart = #1:00:00 AM# However when I would expect to see the variable (defined as a double) contain "0.041666666666", the variable contains "4.16666666666667E-02". If I set the hard coded value to: ThirdStart = #1:30:00 AM# The variable contains the expected result of "0.0625". I have also checked my hardcoded midnight value: Midnight = #12:00:00 AM# which also contains the expected value of "0". This only happens on times between #12:00:01 AM# and #1:29:59 AM#. Anyone have an answer to this problem? I am programming in Excel 2003 for reference. Thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variables with times between Midnight and 1:30am
What is your problem? It is just another way of representing the number. It
is still 1:00AM -- --- HTH Bob (change the xxxx to gmail if mailing direct) wrote in message ups.com... I have an interesting problem, I am writing a function where there are a few hard coded times for the function to use. I am however having problems applying a variable value to 1:00 AM. Here is my code for the variable application ThirdStart = #1:00:00 AM# However when I would expect to see the variable (defined as a double) contain "0.041666666666", the variable contains "4.16666666666667E-02". If I set the hard coded value to: ThirdStart = #1:30:00 AM# The variable contains the expected result of "0.0625". I have also checked my hardcoded midnight value: Midnight = #12:00:00 AM# which also contains the expected value of "0". This only happens on times between #12:00:01 AM# and #1:29:59 AM#. Anyone have an answer to this problem? I am programming in Excel 2003 for reference. Thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is this possible - 2 times 2 variables | Charts and Charting in Excel | |||
After midnight | Excel Worksheet Functions | |||
Time after midnight | Excel Worksheet Functions | |||
Timesheet, overtime with daytime from 7:30am to 16:30pm | Excel Discussion (Misc queries) | |||
How do I sum up a column hours, like 9:30am - 5:30pm, in Excel? | Setting up and Configuration of Excel |