calculate the time between to dates and times

's Computer Specifications

I need to calculate the total time elapsed between two dates and times. What
should I do? Here's an example. Start date/time is 8/24/07 06:15 and the
ending date/time is 8/26/07 12:00 (noon). How do I find the total elapsed
time?

's Computer Specifications

Assuming 8/24/07 06:15 is in A1 and 8/26/07 12:00 is in B1, in C1 enter this
formula:

=A1-B1

then, apply a custom format like [h]:mm to C1.

--
Hope that helps.

Vergel Adriano

"Purple Queen" wrote:

> I need to calculate the total time elapsed between two dates and times. What
> should I do? Here's an example. Start date/time is 8/24/07 06:15 and the
> ending date/time is 8/26/07 12:00 (noon). How do I find the total elapsed
> time?

's Computer Specifications

sorry, I meant:

=B1-A1

--
Hope that helps.

Vergel Adriano

"Vergel Adriano" wrote:

> Assuming 8/24/07 06:15 is in A1 and 8/26/07 12:00 is in B1, in C1 enter this
> formula:
>
> =A1-B1
>
>
> then, apply a custom format like [h]:mm to C1.
>
>
>
> --
> Hope that helps.
>
> Vergel Adriano
>
>
> "Purple Queen" wrote:
>
> > I need to calculate the total time elapsed between two dates and times. What
> > should I do? Here's an example. Start date/time is 8/24/07 06:15 and the
> > ending date/time is 8/26/07 12:00 (noon). How do I find the total elapsed
> > time?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate times between dates and times in Excel	Helio	Microsoft Excel Misc	1	25th Mar 2010 04:29 AM
calculate elapsed time between dates and times	=?Utf-8?B?SmVubmE=?=	Microsoft Excel Worksheet Functions	2	25th Jan 2006 04:39 PM
how do I calculate difference between two dates and times	=?Utf-8?B?UGF0Q04=?=	Microsoft Excel Programming	3	8th Nov 2005 04:15 PM
How do I calculate duration between two dates and times in excel?	=?Utf-8?B?Um9iaW4gQ1NNMDAy?=	Microsoft Excel Misc	2	2nd Jun 2005 05:47 PM
Formula to calculate elapsed time between certain dates and times	=?Utf-8?B?U3RhZGlueA==?=	Microsoft Excel Misc	6	25th Mar 2005 07:02 AM