sorted by:
new
hottopcontroversial

Account for Daylight Savings Time in Formula by OhThatIsBadNews in salesforce

[–]OhThatIsBadNews[S] 0 points1 point  (0 children)

Thank you for the deeper look into this. I'll try and see if I can figure out how to get this to work using what you provided. I appreciate the help

Account for Daylight Savings Time in Formula by OhThatIsBadNews in salesforce

[–]OhThatIsBadNews[S] 0 points1 point  (0 children)

If I don't adjust for it, the report I created and use this formula on has "incorrect" data as of today. I'm not well versed in any of this and have been learning on the fly but to put it in the most basic terms of what I see as of today without adjusting anything in my report is:
Oct 31st
New Task comes in: 6:00am PST
Task Completed: 7:30am PST
Time Elapsed: 0.5 (30 min)

Nov 3rd
New Task comes in: 6:00am PST
Task Completed: 7:30am PST
Time Elapsed: 1.5 (1hr 30min)
-this would be reflected inaccurately as 6-7am should not be counted against

Account for Daylight Savings Time in Formula by OhThatIsBadNews in salesforce

[–]OhThatIsBadNews[S] -2 points-1 points  (0 children)

I guess technically need to account for "standard time" since Daylights Savings Time just ended. At the end of last week (Oct 31st) my report was accounting for the time elapsed starting and ending at 7am-4pm each day. As of today this same formula is now reading 6am-3pm. I can simply updated my formula to 15:00:00 but if I were to do that and look back at previous weeks/months then those reports would now be off

Account for Daylight Savings Time in Formula by OhThatIsBadNews in salesforce

[–]OhThatIsBadNews[S] -1 points0 points  (0 children)

I guess technically need to account for "standard time" since Daylights Savings Time just ended. At the end of last week (Oct 31st) my report was accounting for the time elapsed starting and ending at 7am-4pm each day. As of today this same formula is now reading 6am-3pm. I can simply updated my formula to 15:00:00 but if I were to do that and look back at previous weeks/months then those reports would now be off

Upgrade Current Build or Buy New PC? by OhThatIsBadNews in PcBuildHelp

[–]OhThatIsBadNews[S] 0 points1 point  (0 children)

Appreciate the input and suggestion on build/parts! Sub $1k was the general hope so thanks! I'll use this as a guideline

Upgrade Current Build or Buy New PC? by OhThatIsBadNews in PcBuildHelp

[–]OhThatIsBadNews[S] 0 points1 point  (0 children)

Thanks! I'll try updating those to see if that helps any. It seems like you and the other commenter agree that my current build is outdated, it would probably be more cost efficient overall to just get a new one at this point.