|With 7:45 in A1, put this in A2 and drag it down:|
Each day in Excel is equivalent to 1. Since there are 24 hours in a day and 60 minutes in an hour, there are 1440 minutes in a day.
8/1440 is equivalent to 8 minutes in Excel.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.