Hi Everyone
I need help to calculate the running total of time spent in the attached spreadsheet. Any help?
Thanks
Hi Everyone
I need help to calculate the running total of time spent in the attached spreadsheet. Any help?
Thanks
See attached - Book5.xlsx
Hope this is what you wanted.
Hi LWLS,
Try the file associated with post #4 in the following thread:
http://www.excelforum.com/excel-gene...ml#post3747416
If it does what you want, and you can't implement it in your file yourself, I'll try to implement it in your workbook. If you want it implemented, please specify exactly where (which cell) you want the cumulative time. Your sample workbook is not clear as to what you want.
Lewis
Hi LJMetzger
I'll try your solution and feedback to you soon.
Thanks
See attached with UDF.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Alan,
Nice job, but the data doesn't seem to cooperate. Column 'A' contains date + time, so all the answers are twice what they should be. I think you have to change the formulas in the spreadsheet to be like:
LewisPlease Login or Register to view this content.
If you are looking for the time spent per day then I think that this could be the solution. I used a helper column (for ease of calculation) and added a column that had only the dates then calculated the time spent for each of those dates.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks Lewis. I hadn't noticed that column A had a Time and Date.
Alan
Thanks Lewis. I hadn't noticed that column A had a Time and Date.
Alan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks