I currently have a spreadsheet where I enter electrical meter readings. This is done daily when I am at work and I average readings for when I am off. Some readings are taken at midnight which give a true daily useage and others taken at about 0600 and I use average to correct back to midnight to continue the daily use chart. Is there a better way or formula I could use to achieve what I want to do.