I have been trying to come up with a resolution for this all day. I have the number 30.00 in let's say A2 that represents number of hours. I want it to be formatted in a way that shows 30:00:00(30 hours) so that I can add it to the current date and time. Is this possible?
Bookmarks