Sunday, October 26, 2025
Coding STEM

Parsing date-time string and formatting according to AM/PM (Excel)

Here’s a relatively quick way to parse a date-time string or any string (regardless of data type in your source)  containing date and/or time. It doesn’t matter if the time format is in 12 or 24 hour format, this method works. The time portion of the data can be in HH:MM:SS or HH:MM or similar […]

Read More
Education Life

A quick holidays & events calendar (Excel)

A no-frills demonstration (with actual, real data) of building and publishing a calendar of holidays/events in the United States. Covers 2020 through 2023 and includes major religious, political, and federal events and holidays as a quick reference. Below is the dynamic, real-time version: For interactive tables, visualizations, tips, demos and more, please explore this blog: […]

Read More
Art Break Life

Some of my faves: Live-Streaming Underwater Cams

Here are some of my favorite live-streams of underwater cams. They range from sharks, to coral reef life, to manatees. Also, there’s a link for an hour-long meditation while watching the apex predator of the underwater. Enjoy! Coral City Camera. Miami (FL, USA) Live stream from an urban coral reef in FL. Great streaming and […]

Read More
Back To Top