This method calculates work hours from the displayed time (hh:mm).
Time clocked out – Time clocked in
![](https://eguweb.jp/wp-content/uploads/202208080050-00.jpg)
So, let’s subtract the time of leaving work – time of coming to work.
![](https://eguweb.jp/wp-content/uploads/202208080050-01.jpg)
I got a result that looks like that.
![](https://eguweb.jp/wp-content/uploads/202208080051-00-1.jpg)
![](https://eguweb.jp/wp-content/uploads/e3875f1918a0f093ab49d8cfe3c2f7b3.jpg)
Is that it?
![](https://eguweb.jp/wp-content/uploads/21274626d001642e570a5106bb41707e.png)
Wait a minute…!
Let’s continue.
What is the total operating hours (working hours)…?
If we add up the working hours as is, the total working hours will look strange.
Let’s sum the columns using SUM.
![](https://eguweb.jp/wp-content/uploads/202208080051-00.jpg)
Let’s sum up.
![](https://eguweb.jp/wp-content/uploads/202208080058-00.jpg)
I don’t understand the result…
![](https://eguweb.jp/wp-content/uploads/202208080059-00.jpg)
Calculate by integer value (in hours) (time*24,0)
The formula is 1:00 = 1/(24*60), so we can apply it here to find it.
In other words, if you want to calculate in hours, multiply by 24 to obtain.
Total operating hours = sum(X:X)*24
![](https://eguweb.jp/wp-content/uploads/202208080107-00.jpg)
![](https://eguweb.jp/wp-content/uploads/202208080107-01.jpg)
We get a result of 39.23 hours worked (operating hours)…!
Calculate with integer value (in minutes) (time*1440,0)
If you want to get the result in minutes, you can get the result in integer value (in minutes) by using =time(2460), i.e. =time*1440,0.
![](https://eguweb.jp/wp-content/uploads/202208080108-00.jpg)
We get a result of 2,354 minutes!
![](https://eguweb.jp/wp-content/uploads/202208080108-01.jpg)
Conclusion
As you can see, you can use Google Spreadsheet to find the working hours (total working hours).
Please refer to it 😃.