| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to calculate the difference between sign in and signout time in mi
Changing the Formatting will not change the values stored in the cells
which are used in the calculation, so the values will not be treated as times. If A1 = 850 and B1 = 915 the result would be 65, not 25. In article , Teethless mama wrote: Format Column A and Column B as 00\:00 Formula in C1 =B1-A1 Format as general |
Threaded Mode
