How to Make Excel Read Hours, Minutes and Seconds. While Microsoft Excel automatically reformats time values as hours and minutes, you can manually change the cell's time format to display the ...

Enter the time as "xx:yy" where "xx" is the number of hours worked, and "yy" is the number of minutes worked. Press Enter and Excel will automatically select cell A2. Enter your next payroll time ...