User Profile
Lorenski
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
NEGATIVE TIME VALUE
I have a report that is being exported from Global Shop Solutions > Crystal Reports Viewer and then into Excel. I have 2 columns (I and J in the attached file), one of Estimated hours and anther of Actual hours. There are a few values of negative time--a few, relative to the whole couple hundred thousand rows 🙂 Does anyone have a method for maintaining the negative value? For instance, the top row comes in as -88.54, when it should be -88:54 (negative 88 hours and 54 minutes). As a bonus, does anyone have a method for translating the decimal to a colon for both positive & negative in the same step? I currently have the positive values translated accurately. Just struggling with these negative values now.20KViews0likes1CommentHIGHLIGHT ROW OF THE CURRENT WEEK
I've looked around and tinkered. I just can't land on the right formula, and everyone's situation is slightly different. I need to be able to open up my Excel document and have the row of the current week highlighted. (Some combination of IF, THEN, TODAY, WEEKNUM, etc. in the conditional formatting, is what I've tried to get.) I have ITAR sensitive information so I can't share the whole file. But I shared a screenshot of what is safe.Solved28KViews0likes3CommentsCreating a pair of dynamic graphs for a dashboard presentation
I need to create a pair of donut graphs that detect what week the current day/date falls under. Simply put, we are tracking how many lots/work orders pass final inspection and how many get rejected. This needs to be in a rather simple dashboard style presentation for our Monday Manager's Meeting (MMM) every week. I thought I was going to be able to attach my file but I don't see a button to do that. I'll insert a picture. I want the "PREVIOUS WEEK" graph on the left to detect the current date when they open the file at the MMM, and automatically plot/display the pass/reject info for the previous week. I want the "YEAR-TO-DATE" graph on the right to simply display that: the year-to-date. Obviously, we're not very far into 2022 just yet, but there should be enough there to see what I'm getting at. The formulas/data reference other worksheets, but this is simply a graph question, which is restricted to the sheet in the picture.Solved977Views0likes2Comments
Groups
Recent Blog Articles
No content to show