User Profile
amkdil
Copper Contributor
Joined May 11, 2023
User Widgets
Recent Discussions
Re: total work days from accumulating total work hours
Thanks Hans, but that didn't work, but I don't think I explained it fully enough. I have columns: date, start time, end time, hours worked (which can vary), total hours (which is the sum of all hours worked). I then need the next column to give 'total days worked' where the 'total hours worked' is divided by 7 hour days.386Views0likes1Commenttotal work days from accumulating total work hours
Hi. I'm trying to find the formula which calculates total work days (of 7 hours) from column D (which gives a running total of hours worked), but which also avoids a problem of when 24 hrs is reached (which is an issue I've only read about). Hope this is enough detail. Thanks in advance. AntonySolved642Views0likes9CommentsHow to avoid a #value error due to source cell being blank but containing another formula
Hi, I am using the following formula: =IF(AND(D3="",E3="",F3=""),"",D3+E3+F3) to sum three cells but to return a blank (rather than 0) if all source cells are empty. This works fine in other areas of my spreadsheet where all source cells are either empty or contain numbers, however, in this case, cell D3 contains a very simple =IF(D2="","",(D2)) formula, which when this returns a blank (because D2 is empty), I get the #value error. Any tips on how to avoid this error, please? Thanks in advance, AntonySolved704Views0likes2CommentsExcel (365) date format (in cell) won't change from number of days since 1/1/1900
Hello. I seem unable to change the date format from the number of days since 1/1/1900. I have tried all different date formats, and despite the actual date showing correctly in the formula bar, the cell will only display as 44234 etc. Any ideas please? Thanks in advance.894Views0likes2Comments
Recent Blog Articles
No content to show