Hi,
Can you please advice me how to calculate time differences.,an example is
below for you to advice and solve my query..,
A B
1 01/03/2007 06:00:00 02/03/2007 07:30:00

The time (hours, mins & sec) taken between B1 to A1 is 25hours & 30 mins.
Can you please adivce me how to arrive to this formula.

Just subtract:

=B1-A1

Format the cell as [h]:mm

Result = 25:30

Biff

"Ajay" wrote in message
...
Hi,
Can you please advice me how to calculate time differences.,an example is
below for you to advice and solve my query..,
A B
1 01/03/2007 06:00:00 02/03/2007 07:30:00

The time (hours, mins & sec) taken between B1 to A1 is 25hours & 30 mins.
Can you please adivce me how to arrive to this formula.

On Sat, 3 Mar 2007 13:38:05 -0800, Ajay wrote:

Hi,
Can you please advice me how to calculate time differences.,an example is
below for you to advice and solve my query..,
A B
1 01/03/2007 06:00:00 02/03/2007 07:30:00

The time (hours, mins & sec) taken between B1 to A1 is 25hours & 30 mins.
Can you please adivce me how to arrive to this formula.


=B1-A1

Dates and times are stored as days and fractions of days.

Format appropriately.

e.g. [h]:mm
--ron

Hi,
I tried with the formula (=B1-A1), it calculates the time difference alone
and it shows as only the time difference as 01hrs & 30mins, it does not
calculate the day difference.????!!!
I wonder how it works., can you pls assist in dept. Also advice on the topic
named Time calculation (idle time) subtraction!.
Thanks for your reply.:-)
--Ajay--

"Ron Rosenfeld" wrote:

On Sat, 3 Mar 2007 13:38:05 -0800, Ajay wrote:

Hi,
Can you please advice me how to calculate time differences.,an example is
below for you to advice and solve my query..,
A B
1 01/03/2007 06:00:00 02/03/2007 07:30:00

The time (hours, mins & sec) taken between B1 to A1 is 25hours & 30 mins.
Can you please adivce me how to arrive to this formula.


=B1-A1

Dates and times are stored as days and fractions of days.

Format appropriately.

e.g. [h]:mm
--ron

Read again the reply you were given below:

" Format appropriately.

e.g. [h]:mm"
--
David Biddulph

"Ajay" wrote in message
...
Hi,
I tried with the formula (=B1-A1), it calculates the time difference alone
and it shows as only the time difference as 01hrs & 30mins, it does not
calculate the day difference.????!!!
I wonder how it works., can you pls assist in dept. Also advice on the
topic
named Time calculation (idle time) subtraction!.
Thanks for your reply.:-)
--Ajay--

"Ron Rosenfeld" wrote:

On Sat, 3 Mar 2007 13:38:05 -0800, Ajay
wrote:

Hi,
Can you please advice me how to calculate time differences.,an example
is
below for you to advice and solve my query..,
A B
1 01/03/2007 06:00:00 02/03/2007 07:30:00

The time (hours, mins & sec) taken between B1 to A1 is 25hours & 30
mins.
Can you please adivce me how to arrive to this formula.


=B1-A1

Dates and times are stored as days and fractions of days.

Format appropriately.

e.g. [h]:mm
--ron

Hi David Biddulph,
Thanks for the assistance.,Hurray! Its working..,
:-)
Thanks once again.
--Ajay--

"David Biddulph" wrote:

Read again the reply you were given below:

" Format appropriately.

e.g. [h]:mm"
--
David Biddulph

"Ajay" wrote in message
...
Hi,
I tried with the formula (=B1-A1), it calculates the time difference alone
and it shows as only the time difference as 01hrs & 30mins, it does not
calculate the day difference.????!!!
I wonder how it works., can you pls assist in dept. Also advice on the
topic
named Time calculation (idle time) subtraction!.
Thanks for your reply.:-)
--Ajay--

"Ron Rosenfeld" wrote:

On Sat, 3 Mar 2007 13:38:05 -0800, Ajay
wrote:

Hi,
Can you please advice me how to calculate time differences.,an example
is
below for you to advice and solve my query..,
A B
1 01/03/2007 06:00:00 02/03/2007 07:30:00

The time (hours, mins & sec) taken between B1 to A1 is 25hours & 30
mins.
Can you please adivce me how to arrive to this formula.


=B1-A1

Dates and times are stored as days and fractions of days.

Format appropriately.

e.g. [h]:mm
--ron