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
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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> >
> >
> >
Format the result as Custom [h]:mm otherwise the sum will "tip over" each
24 hrs
--
Kind regards,
Niek Otten
"Bob Phillips" <[email protected]> wrote in message
news:%23jA%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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" <[email protected]> wrote in message
>> > news:[email protected]...
>> > > 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
>> >
>> >
>> >
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks