calculation

A

Ajay

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.
 
R

Ron Rosenfeld

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
 
A

Ajay

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 said:
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
 
D

David Biddulph

Read again the reply you were given below:

">> Format appropriately.
--
David Biddulph

Ajay said:
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 said:
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
 
A

Ajay

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

David Biddulph said:
Read again the reply you were given below:

">> Format appropriately.
--
David Biddulph

Ajay said:
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 said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top