Re: Adding variable hours to current time
- From: "Bill Marriott" <wjm@xxxxxxx>
- Date: Sat, 1 Jul 2006 15:53:34 -0400
Try this out:
t (timestamp, auto-enter modification timestamp)
n (number)
r (calculation, timestamp result)
= t + n
Now enter a 1 into n. You see that r shows t + one second.
Put 60 into n. You see that r shows t + 1 minute.
Put 3600 into n. You see that r shows t + 1 hour.
Put 36000 into n... d is now t + 10 hours.
Do you see a pattern emerging? If not, add:
h (number)
r2 (calculation, timestamp result)
= t + h * 3600
Now, go into layout mode. Specify a time format and a date format that shows
the day of the week. Try different values for h.
"Matt Wills" <Im@xxxxxxxx> wrote in message
news:O9xpg.792$0V1.701@xxxxxxxxxxx
I have a need to add various values ranging from 4 to 36 hours to the
current time, the goal being to display that new time along with its date
and day of week.The manufacturing process prompting this is a 24/7
thing, thus any of the specified durations could take it to the next
calendar day, and, in the case of 36 hours, the day after.I had hoped that
it would be as simple as adding to a timestampManipulating the numbers
equivalent to date and time is overloading my PPC (Personal Processing
Capacity). Maybe I should wait until afternoon to do this stuff?Any
guidance appreciated (custom functions welcome).Matt(FMA8, WXP/Mac)--
.
- Follow-Ups:
- Re: Adding variable hours to current time
- From: Matt Wills
- Re: Adding variable hours to current time
- References:
- Adding variable hours to current time
- From: Matt Wills
- Adding variable hours to current time
- Prev by Date: Adding variable hours to current time
- Next by Date: Remove security
- Previous by thread: Adding variable hours to current time
- Next by thread: Re: Adding variable hours to current time
- Index(es):
Relevant Pages
|
