Hi fellow Excel fans,
Recently I got to have a lot of fun with some great Excel formulas!
One of the things that I love to do is monkey around in Excel with some data. I unfortunately won't be doing what I have been doing for the past few years since I switched jobs but you never know! I got really good at doing things in Excel so maybe my new company will appreciate that and I can do some of this stuff on the side for them?
What I was doing in these situations was looking at things for timeframes. The first one was trying to determine what part of the day something was done on. The particular individual was looking to figure out what was done between the hours of 0700 and 1900 for one piece then the other was looking from 1901 to 0659. Converting all of this stuff into military time really saved a whole lot of headache!
Thankfully with the data I got, and this really great formula, I was able to have Excel do the calculations for me and make simple work out of what would have taken hours per dataset! I ended up using this same exact formula three additional times after the first go-round! I was so thankful I did what I did.
The other formula piece I used was to look at what took over an hour and what took less than an hour. Turnaround times are an important piece of information for folks in many areas so I was more than happy to oblige. I have worked with turnaround times quite a bit over the years since that's a very popular item to request but this was my first time doing the calculations myself instead of having the software I got the data out of, doing it for me. I was happy with the result, since the same files I reference above were utilizing both of these formulas. Three files with this stuff ended up being a whole lot of fun!
=IF(AH2="","",IF(AH2>(--"1:00:00"),"Over 1 Hour","Less Than 1 Hour"))
=IF(AND(AD2>=TIMEVALUE("7:00:00"),AD2<=TIMEVALUE("19:00:00")),"7a-7p","7p-7a")
I know not everyone is as excited for Excel work like this but I enjoyed it and had fun doing it and learning. If only I could do stuff like this more often and get paid decent money to do it lol oh well, hopefully it will help in the long run! I know my wife still uses her Excel skills now that we have our small business. She's doing quite a bit of calculations and all that to satisfy what she's looking for but at the same time to keep up with her skills.
Connect with me!
Do you want to get paid, in crypto, for searching the internet? Try using and signing up for Presearch to earn some great crypto! I've currently got 2,470 PRE tokens, with a market value of $59.28. It doesn't sound like a lot but when you search using sites like Google you get paid $0! Join Presearch to break Google's stranglehold on the internet searches. If you'd like to sign up, use my referral link!
https://www.presearch.org/signup?rid=513043