It will show an error with the value of hash characters (#) in the cell.For example, if the start time is 8:00 pm on Day 1, and the end time is 7:00 am on Day 2, the start time becomes greater than the end time, then the (end time – start time) formula will give a negative value.In that case, the calculation is to be done differently. Now the problem is when the time crosses midnight.This represents as times and hours are fractions of 1. In Excel, one day means 1, which is 24 hours.Press Enter button, and the result will show as 30. Write the formula as “ = MINUTE (B3-B2)” to calculate the exact minutes irrespective of the hours and seconds. Press Enter button, and the result will show as 2. Write the formula as “= HOUR( B3-B2) “to calculate the exact hours irrespective of the minutes and seconds. We want to calculate the time difference between 6.30 pm and 9.00 pm.Suppose the time difference is in an hour: minute format, and we want to see the hour and minute difference in separate cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |