I am having cell formatting issues.
first lets do the math. I have 77 items and it takes 2.7 minutes to move one of them from point a to point b.
Doing the math it will take 207.90 total minutes to move all 77 pieces. 77 is in cell A1 and 2.7 is in Cell A2.
The formula I am using is
. The result is 207.90 in cell A3. What I need is to show Days:hours:minutes in cell A3 so that the result is 00:03:27. o days:3 hours: 27 minutes. I have tried custom formatting with dd:hh:mm and it does not give me the result that I need. Can't figure out what I am doing wrong.
Bookmarks