quotes
2 TopicsOutlook for Mac quote button
Hi all, It has been a few months since I migrated to MacOS from Linux. During my days in Linux, I use Outlook web version and now I have been using Outlook app for Mac. One feature that I missed is quote button, which I use quite a lot! It seems that the Outlook app in Mac doesn't have quote button, for some reason. What I usually do is copy pasting and then put an indentation and italic, which is OK, but not nearly as polished. It would be really great to have this feature added in. In the meantime, is there any alternative to 'save' a style for quote that is similar to the web version? Thanks!1.5KViews5likes1CommentTrouble quoting date+time(hour/mins) of project start date/completion using the WORKDAY function.
Hello, I'm currently tasked with completing an excel document that accurately quotes job start and completion dates (including time of day within a work shift). So far I've been able to come up with a system that works for the most part but I'm having some issues relating to the WORKDAY function. My goal is to have an input start date/time (ex. Wednesday July 10, 2019 7:00 AM) which in turn will generate accurate information of the completion date/time for the job and simultaneously calculating when the next job will start/finish (start date/time is the finish date/time of the previous job). Ex: Start: Wednesday July 10, 2019 7:00 AM - Finish: Thursday July 11, 2019 2:55 PM. Start: Thursday July 11, 2019 2:55 PM - Finish: Friday July 12, 2019 9:45 AM. So far I've been able to calculate the finish "date" but I'm having troubles with the information generating the "time" of completion and therefore the next jobs start date/time (specifically time) correctly. The system seems to be generating the "day of completion" fine but the "hours/mins" are not calculated into the equation. I would like the WORKDAY function to be set to 7:00am - 3:30pm but I'm not sure if this is possible. The document is referring to a chart which calculates the approximate time it takes to complete a specific job depending on the amount of "parts"and "blades". (ex: (#of parts * #of blades) * Time Per Blade = Total time (0.0 days) .) The total time is then used in the workday calculation: WORKDAY(start_date, Total Time, no holidays). I'm not sure if I'm using the WORKDAY function incorrectly or not. The end goal is to have it calculate the date and time of day when a job will be competed, then in turn generating the next jobs start time. Attached is the document for better clarity. Any help would be appreciated. I'm fairly new to excel so spare me the criticism if this is a common error. Thanks!4KViews0likes5Comments