How to use IF Function for Time Calculation
Requirement:
What the user needs is the following:
If the first login is earlier than the shift time to make the tardiness 0.
If the first login is after the shift time to calculate the difference in minutes.
Solution:
Try this version:
=IF(E3<MOD(F3,1),0,F3-E3)
Obtained from the OzGrid Help Forum.
Solution provided by NBVC.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| How to use VBA code to transpose any copy values X number of times |
| How to use code to insert below and copy the row as many times as the cell contains |
| How to find and insert rows for missing timestamps, remove rows for unwanted timestamps |
| How to create VBA code for a workbook to work on week days only and specific range of time |
| How to create VBA code to increment number each time a copy is printed |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
