Re: Another Days, Hours, Minutes, Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Sorry for the rambling...
I need a routine for computing a time period -- using a historical date
(hh:dd:mm) subtracted from the present date (now()), output as dd:hh:mm.
This will be 24hrs/day, 7 days/week, 365 days/year operation, no limit to
period length.

I've read messages concerning issues when calculating time over days when
you want it in days, hours, minutes format -- using +1 or -1 to get correct
days or minutes when exceeding 24 hours.

Just looking for a better routine..

Thanks,


"Bob Phillips" wrote:

I am not getting what your problem is, what are you looking for help with?

--
__________________________________
HTH

Bob

"ShagNasty" <ShagNasty@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:67D55977-A1E7-4337-A914-ECD6071A8F98@xxxxxxxxxxxxxxxx
Reading through the Discussion Group I find many Date/Time questions and
answers but none I can find that meets my exact needs. The topics seem to
address Hours, Days, with or w/o weekends, holiday, work hours, or work
days,
etc. - not just vanilla output containing the calculated Day(s), Hours,
and
Minutes between two dates.

Below is an example of a small spreadsheet used to capture equipment
runtime
for history and other tasks. I've used this spreadsheet for several years
(my first attempt at excel - too embarrassed to show formula) and
sometimes I
am suspect of the results. I truly believe that one of you gifted ladies
and/or gentlemen can provide me with a simple Macro to end my doubts.

Thanks..

A B C
1 Start Time Current
2 Name Date / Time Run Time
3 Widget 1 04/24/2008 22:13 dd:hh:mm
4 Widget 2 10/12/2008 20:55 dd:hh:mm
5 Widget 3 10/02/2008 04:19 dd:hh:mm
6 Widget 4 11/06/2008 23:59 dd:hh:mm
7
8
9 =now()

-- 24 x 7 x 365 Industry -- forget weekends, holidays, work hours, etc..
-- 24 hour time format
-- Cell A9 would contain present time/date function -- now() or today()
whichever is best.
-- C3 would contain A9-B3 in dd:hh:mm
-- C4 would contain A9-B4 in dd:hh:mm
-- C5 would contain A9-B5 in dd:hh:mm
-- C6 would contain A9-B6 in dd:hh:mm
-- Data in B3, B4, B5, & B6 will be input when Widget is started
-- If the widget is going to be "off" for an extended time period, I will
input the planned future start time/date so employees can see remaining
time
"countdown" till startup
-- Widget runtime is not predicable (wish it was) - maybe hours, days,
months, or years..

Thanks again -- Shagnasty....



.

Relevant Pages

  • Re: {OT} Why they threw a shoe at Bush
    ... history of that time period when we "ended up with" Puerto Rico. ... independence to the Philippines was nothing short of revolutionary at the ...
    (alt.autos.toyota)
  • Re: {OT} Why they threw a shoe at Bush
    ... history of that time period when we "ended up with" Puerto Rico. ... frequently notes that American policies were far less exploitative and more ... politically liberal than any other colonial administration in history. ... he argues that the Washington's voluntary grant of independence to ...
    (alt.autos.toyota)
  • Re: "300" judged...
    ... from that time period, but he is the only source of any real ... or any others on here are aware of any other rich sources of history ... While he was indeed the only source of that period with any substance, ... he was a Greek writing about a conflict between the ...
    (rec.sport.football.college)
  • Re: Gilbert fitzReinfrid son and heir..Further..
    ... in this time period in England, then neither did avunculus "properly" ... connote a maternal uncle in this time period. ... M.A. History '83 ...
    (soc.genealogy.medieval)
  • Re: Yankees at a Crossroads?
    ... history was changed forever. ... I am beginning to wonder if the Yankees, ... and history will answer these questions. ... He'd relied on his own routine. ...
    (alt.sports.baseball.ny-yankees)