![]() ![]() The square bracket syntax tells Excel to display hour durations of greater than 24 hours. In cases where calculated time exceeds 24 hours, you may want to use a custom format like :mm. By using MOD with a divisor of 1, positive results are unchanged, but negative results (which occur when start time is greater than end time) are "flipped" to get a correct duration.įor more details, see: How to calculate number of hours between two times Formatting time durations This formula uses the the MOD function to handle times that cross a day boundary (midnight). ![]() ![]() Next, break time is subtracted from work time to get "net work hours". MOD (C6 -B6, 1 ) // get work time MOD (E6 -D6, 1 ) // get break time ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |