Maximum / 1 day / 24 hours /1440 mins / 86 400 sec in put

**zit1343** · 06-29-2011, 04:45 PM

Hi
I am making excel report and report will generate by daily baises user can enter day hours minutes or seconds, but the maximum I want user to all for input is
1 day OR 24 hours OR 1440 mins OR 86 400 sec
please help me if user enters more than anything I shown above it should give user error
please help me
Thank you

**Paul** · 06-29-2011, 04:55 PM

How are the users selecting the time increment (d/h/m/s)? Are they typing it in the same cell as the number, e.g.

14 hours 8 minutes 32 seconds

Or are they typing a number in one cell and selecting a time increment from another? Or are you using a user form? Or ActiveX objects? Or....?

**ChemistB** · 06-29-2011, 04:58 PM

I assume this is all occuring in a single cell (let's say A2)?
How does Excel know that the user is entering seconds, minutes, hrs, etc?
So if the user enters 23, is that minutes or hours? is there a second cell which has the units in it?

**zit1343** · 06-30-2011, 08:44 AM

Hey guys thanx for thoughts
here is whats going on

lets say B1 is where user will enter the start time, start time can be either be excat date format, or 1 day or hour, minute, or second format
and end time will be same end time will be in B2 lets say

B1 & B2 are linked from ADDON on excel.