Table for calculating working hours

  1. Enter an equal sign
T7MNXCkvWsbRbvOxGV6mb4 k3Zp0sIv59jhHSOO4Q6tD1scL DzgiOChiPKnBFfCL461UCWHFP Mrs5SXrL7sNowEfwmVoO93SaPlXnNC2YqOtpxN ALhDJgBDCOrioQs qF Qnv gCMkg5M9bkBCTU
  • Put an equal sign ( = ) in an empty cell.
  1. Enter the end time and multiply by 24
5xw4 KK01tbyE7 kWkgXmhySRwZkjaLoWfWPhiB
  • Enter the cell address with the ending time immediately after the equals sign to convert it to a decimal number.
  1. Subtract the start time multiplied by 24
SSEHV7teb9rwmttibqG6GNeHH 9TJGvtiVJINfHsys1Vi3au9CTPHMZHCuzAx6ToZGhZ733Zm4V79rttivalO1VTHql6qLVBMyfc V 2sbbN1
  • Insert a minus sign ( – ).
  • Enter start time and multiply by 24 to convert to decimal.
  • Enclose these terms in brackets ().
  1. Press Enter
X2aZnTS Cv 9vUIRgLW3ACapHeUmauY rvK16Q1swM
  • Press Enter to calculate the working time.
  1. Apply the formula to each row
eg2HY44NqO2e
  • Apply formulas to each row using select handles and drag and drop methods.

Table of Contents