Hi, I have a column with time duration values as string. The format is "hh:mm".
But when I want to summarize all the values is impossible. How can I do that?
Hi, I have a column with time duration values as string. The format is "hh:mm".
But when I want to summarize all the values is impossible. How can I do that?
Welcome to the forum.
How are you trying to summarise the times? Not enough information.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Time is just a numeric value. So today's date in numeric value is 43685. So today at 9:15 a.m. is 43685.39, noon would be 43685.5.
So what do you have and how do you expect to see it summarized?
A sample workbook with data you have AND expected results would be helpful.
click on Go advanced (under this quick reply box) then manage attachments then browse and upload to upload a workbook.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks