Calculate the difference two times
 

Hi,
Please show me to fix these problems. Thanks
Ex: 12:30 Am - 11:25 Pm= #VALUE
and
2:50-2:52=# VALUE.


Thank you
Chi

With your times in A1 and B1
=MOD(B1-A1,1)

--
Regards
Roger Govier
"Chi" wrote in message
...
Hi,
Please show me to fix these problems. Thanks
Ex: 12:30 Am - 11:25 Pm= #VALUE
and
2:50-2:52=# VALUE.


Thank you
Chi

On Sat, 16 Jul 2005 06:20:02 -0700, Chi
wrote:
Please show me to fix these problems. Thanks
Ex: 12:30 Am - 11:25 Pm= #VALUE
and
2:50-2:52=# VALUE.

Or, assuming that your times are in A1 and B1:

=IF(A1B1,A1-B1,B1-A1)

Or..

Change your times for 12:30am where you're tracking from the previous
day to 24:30 instead of 00:30.

MP-

--
"Learning is a behavior that results from consequences."
B.F. Skinner