calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...


=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 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.
Click to expand...


=B1-A1

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

Format appropriately.

e.g. [h]:mm
--ron
Click to expand...
 
Read again the reply you were given below:

">> Format appropriately.
e.g. [h]:mm"
Click to expand...
Click to expand...
--
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.
Click to expand...


=B1-A1

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

Format appropriately.

e.g. [h]:mm
--ron
Click to expand...
Click to expand...
 
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.
e.g. [h]:mm"
Click to expand...
Click to expand...
--
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top