wehuberconsultingllc.com

Excel Round time to the nearest quarter hour

I screwed up with my paysheet calculation for one of our employees on our farm for the last pay period. I was calculating the number of hours worked in my head. One of our employees pointed out the mistake and I decided to minimize future mistakes by letting Excel do the math for me. The hard part was rounding to the nearest quarter of an hour till I found this link. Thanks Mr. Excel!

I guess the next thing to do is to create an IIF file to import into QuickBooks.

Related posts:

• Excel Tip: Converting CSV files into IIF files
• Problems importing IIF transactions into QB2004
• Update to Excel Macro to import IIF transactions
• Importing bills into QuickBooks Pro
• New Excel Macro to import IIF transactions