Our firm bills clients in six-minute increments, so I’ve started tracking my beginning and ending time for each job in Excel. Is it possible to round my time calculations to the nearest six-minute increment (a 10th of an hour) in Excel? To read the full article in the Journal of Accountancy, click: Microsoft Office: Rounding Time in Excel.
-
-
Annie Cushing is on a Mission to Rid the World of Ugly Data. Learn About Data Collection, Analytics, Technical SEO, Analysis, and Beautification. Annie Cushing, a Senior SEO at SEER Interactive, a Philadelphia-based online marketing agency, explains that “There comes a time in a marketer’s life when making pretty charts with a predefined dataset just doesn’t cut it. “And finding the sum and average of a column of data just doesn’t satisfy you anymore. Eventually — and it’s really inevitable — you will actually have to dive deep into the data and cull out a smaller dataset or manipulate it…