Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time
I am having a problem with calculating time. I can calculate the difference
in hours over midnight, but what I can't do is not get a value to appear when I have only put in one number...For instance. I put in the time I start, and in my hours it shows midnight minus those hours without me putting in an ending value for hours worked.. Is there anyway to get this to show an error if they only put in a start time and no quit time? Hopefully this makes sense to someone out there. Any information anyone can give would be helpful. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time
On Apr 19, 2:13 pm, "Huston" wrote:
I am having a problem with calculating time. I can calculate the difference in hours over midnight, but what I can't do is not get a value to appear when I have only put in one number...For instance. I put in the time I start, and in my hours it shows midnight minus those hours without me putting in an ending value for hours worked.. Is there anyway to get this to show an error if they only put in a start time and no quit time? Hopefully this makes sense to someone out there. Any information anyone can give would be helpful. Thanks You wanna give us the formula you're using so we can see what you've already got? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time
Answered in m.p.excel.
In article , "Huston" wrote: I am having a problem with calculating time. I can calculate the difference in hours over midnight, but what I can't do is not get a value to appear when I have only put in one number...For instance. I put in the time I start, and in my hours it shows midnight minus those hours without me putting in an ending value for hours worked.. Is there anyway to get this to show an error if they only put in a start time and no quit time? Hopefully this makes sense to someone out there. Any information anyone can give would be helpful. Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time
On Apr 19, 2:16 pm, okrob wrote:
On Apr 19, 2:13 pm, "Huston" wrote: I am having a problem with calculating time. I can calculate the difference in hours over midnight, but what I can't do is not get a value to appear when I have only put in one number...For instance. I put in the time I start, and in my hours it shows midnight minus those hours without me putting in an ending value for hours worked.. Is there anyway to get this to show an error if they only put in a start time and no quit time? Hopefully this makes sense to someone out there. Any information anyone can give would be helpful. Thanks You wanna give us the formula you're using so we can see what you've already got? It would also be great if you didn't post your question in multiple places... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time calculations for Scheduled Time vs. Actual Time Worked | Excel Discussion (Misc queries) | |||
straight time, time and a half, and double time | Excel Discussion (Misc queries) | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |