| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
| Calculate the difference between two times | Excel Worksheet Functions | |||
| How can I calculate the difference between times without using th. | Excel Worksheet Functions | |||
| how do i calculate minutes between two times? | Excel Discussion (Misc queries) | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Linear Mode
