Re: > 24:00

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

From: Myrna Larson (myrnailarson_at_chartermi.net)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 10:39:27 -0500

I just tried Frank's format (I should have done that before posting what's
below!) and in fact it *will* display 0 for the day for a period less than
24 hours. So Frank's solution is correct, and you don't need to modify the
calculation or use different formats form times more than one day.

I don't know why the OP says that 25 hours displays as 2 1:00. For me it
shows 1 1:00.

"Myrna Larson" <anonymous@discussions.microsoft.com> wrote in message
news:8e1hl0hun5l2989q637ikviri2babesgku@4ax.com...
> In thinking about it further, the formula I proposed will always show the
> number of days as 1, even when the time is less than 24 hours. That's
> because
> a "d" in the format string means the day of the month. You can't display a
> 0
> because there's no 0th day of the month.
>
> With that formula, if B1-A1>1, you could use the format d hh:mm, but if
> B1-A1<1, the format would have to be "0 "hh:mm
>
> But there's no way to set up a conditional number format that looks at B1
> and
> A1; it looks at the value in the cell that's being formatted.
>
> So I think you are "stuck" with displaying the number of hours as
> something
> greater than 24 here.
>
> On Mon, 27 Sep 2004 12:28:56 -0500, Myrna Larson
> <anonymous@discussions.microsoft.com> wrote:
>
>>Modify your formula to
>>
>> =IF(B1-A1>1,B1-A1-1,B1-A1)
>>
>>Then format as Frank suggests. But note that this modifies your data, so
>>you
>>won't get the correct result if you add such numbers.
>>
>>Most of the time you leave the original formula alone and instead format
>>the
>>cell to shows hours > 24 (pick the format that does that from the list of
> time
>>formats).
>>
>>On Mon, 27 Sep 2004 03:59:07 -0700, "an"
> <anonymous@discussions.microsoft.com>
>>wrote:
>>
>>>Thanks for your reply.
>>>
>>>Oops!
>>>
>>>25:00
>>>Return 2 01:00
>>>When it would have to be 1 01:00
>>>
>>>Thanks.
>>>an
>>>
>>>>-----Original Message-----
>>>>Hi
>>>>format the output cell with
>>>>d hh:mm
>>>>
>>>>--
>>>>Regards
>>>>Frank Kabel
>>>>Frankfurt, Germany
>>>>
>>>>"an" <anonymous@discussions.microsoft.com> schrieb im
>>>Newsbeitrag
>>>>news:428f01c4a47e$9a266aa0$a601280a@phx.gbl...
>>>>> I have a formulae to sum hours conditionaly:
>>>>>
>>>>> =SUMPRODUCT(--(colorindex(A1:A3;TRUE)=3);--(A1:A3>TIME
>>>>> (24;0;0));A1:A3)
>>>>>
>>>>>
>>>>> If result will be greater that 24:00, for example 25:00,
>>>>> the formulae return 1:00.
>>>>>
>>>>> Is possible to get 1 day and 1:00 hour, please?
>>>>>
>>>>> Thanks in advance.
>>>>> an
>>>>
>>>>.
>>>>
>

Relevant Pages

  • Re: How to customize the output format of function dataset?
    ... It's line 85 of @dataset/disp that is where you want to go, ... However, since this is in a class directory, you'll have to modify it in place, which requires appropriate privileges for your MATLAB install directory. ... I will make a note to look into enhancing the display method for the dataset in the future. ... Just out of curiosity, would it be sufficient for your needs if the display respected the current setting of the FORMAT command? ...
    (comp.soft-sys.matlab)
  • Re: never ending problems
    ... you're modifying a heading style. ... In the Modify Style dialog there is a Format button. ... Modify:>> Format: Paragraph applies only to paragraph formatting, ...
    (microsoft.public.word.numbering)
  • Re: Word Manuscript -> Book Format
    ... What you want to do is modify the styles. ... if your body text is 12 pt TNR in your manuscript but you want it ... > Suzanne S. Barnhill wrote: ... The manuscript is in A4 format, ...
    (microsoft.public.word.formatting.longdocs)
  • Re: Outline Styles
    ... Styles pane and choose Modify from the context menu. ... Click Format, Paragraph. ... them hang because I hang the second line. ...
    (microsoft.public.word.docmanagement)
  • RE: date format to dd mm yy
    ... I understand that you want to know how to change the display of date ... the date format can only be changed when you change ... (language ID 1033), the date format is in mm/dd/yyyy. ... This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.windows.server.sbs)