Re: How do I calculate time durations over numerous dates

Format the result as Custom [h]:mm otherwise the sum will "tip over" each
24 hrs

--
Kind regards,

Niek Otten

"Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23jA%23jSe9FHA.2176@xxxxxxxxxxxxxxxxxxxxxxx
> Why not? It will still have a valid value, it just differs how you present
> it.
>
> One way would be
>
> =INT(A2-A1)&" days, "&TEXT(MOD(A2-A1,1),"hh:mm:ss")
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "MBubier" <MBubier@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:EC1D08B8-B891-4E46-A1FF-381107CF0332@xxxxxxxxxxxxxxxx
>> I've got that, but what about including different dates? I tried
> formatting
>> the cell such that the date is also part of the entry but then I can not
>> subtract them.
>>
>> "Bob Phillips" wrote:
>>
>> > If you enter them as standard time, such as 09:15:30, then just
>> > subtract
>> > them to get the duration, and format that as time also.
>> >
>> > --
>> >
>> > HTH
>> >
>> > RP
>> > (remove nothere from the email address if mailing direct)
>> >
>> >
>> > "MBubier" <MBubier@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> > news:78CA51F3-1AA8-4CE6-B4F7-05561777A4BE@xxxxxxxxxxxxxxxx
>> > > I am trying to enter data that was collected on different dates/times
> and
>> > > calculate the duration of the entire data collection. How can I
>> > > enter
> the
>> > > dates and time such that I can calculate the duration? I am using
> Excel
>> > 2000
>> >
>> >
>> >
>
>


.

Relevant Pages

  • Re: Zero values displaying as "-"
    ... HTH ... (remove nothere from the email address if mailing direct) ... > Here is the formatting I'm currently using: ...
    (microsoft.public.excel.newusers)
  • Re: IF formula
    ... (remove nothere from the email address if mailing direct) ... > need this row to subtract the numbers entered into rows G, M-U only. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: If Statement?
    ... (remove nothere from email address if mailing direct) ... Hey everyone, ... make it 9 and subtract 1 ...
    (microsoft.public.excel.newusers)
  • Re: percentage help
    ... looking out across Poole Harbour to the Purbecks ... (remove nothere from the email address if mailing direct) ... > How would I make a function that would allow me to subtract a percentage ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Naming a (date) constant
    ... i know its just a matter of formatting it, ... > "Bob Phillips" wrote in message ... >> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.worksheet.functions)