Forum Discussion
Time formula
Yes, it works, thank you, just the total does not work, any idea? OK, I got the total to work. Thank you very much. I'll buy you a beer if you ever come to my bar in Thailand. Cheers.
Glad you solved the total yourself. I'll let you know when I'm near 🙂
Riny_van_Eekelen Hi again, well I thought I found the formula and got the right answer, but then it disappeared. Now I can't get it to work again. Do you come to Thailand?
See attached. It's important to format the total cell correctly. My initial thought was to have it as a decimal number. Then you would sum the hours and multiply by 24 and format it as a number. Alternatively, you can just format the summed hours as a Time but in a special way. It's indicated in the attached workbook.
No, not planning to come to Thailand anywhere soon. It was 22 years since I was there.
Thought we had it, but the total is wrong, probably me doing something wrong.
I formatted C35 to (H):MM:SS
I'm in Hua Hin, did you ever get there?