name day1 day2 day3 day4 day5 totalhr DAY
person1 2hr 4hr 1.5hr 1hr 2hr 11.5
Person2 3hr 2.4hr 2hr 2hr 3hr 12.5
Person3 3hr 2hr 2hr 2hr 3hr 12hr
I have an Excel sheet that has text values (like the examples above).
I want a way I can convert them into days such that:
If I have 12hrs, it rounds off to the nearest day and becomes 1 Day. If it is more than 12 hrs, it can say for example 1 day 2 hrs. Until the 2hrs grows to 12hrs it becomes 1 day.
It is important to note that the values are in General format and not date or time.
I see the hours is making it so difficult.
Can we ignore the hrs from both the input value: it should be total 12 = 1day 3hr (where 3 is the hours or without hr).
I don't want to convert to strings. If the formula is without hrs it is fine. My point is how to had i.e. 2 , 3 , 1, each representing hours when it gets to a total of 12, it becomes one day. 12 hours = 1 day. you can ignore hrs in the formula.
Thanks
1.5hr
), or how to do the rounding? Please do not respond in comments; edit your question to make it clearer and more complete.