Time Summary (Monthly)
Author: sampomichExecutions: 24
※ This library was created by a member. This site is not responsible for its content.
It simply tallies monthly hours and calculates cumulative hours. It accumulates hours without distinguishing between overtime and other types of hours.
If the same number of hours appears multiple times, enter it in the “Count” column, and the total will be calculated as a multiple of that number.
If you add a minus sign to a number in a column, that row will be counted as a subtraction.
If you enter “0” in the “Count” column, that row will be excluded from the total.
Switch to the “Minutes” field to enter minutes as a decimal in the “Hours” field.
Replace the colon (:) in the “Hours” field with a period (.) to enter the time as “Hours.Minutes.”
1:10 ⇒ 1.1, 1:01 ⇒ 1.01
If you add a minus sign to a number in a column, that row will be counted as a subtraction.
If you enter “0” in the “Count” column, that row will be excluded from the total.
Switch to the “Minutes” field to enter minutes as a decimal in the “Hours” field.
Replace the colon (:) in the “Hours” field with a period (.) to enter the time as “Hours.Minutes.”
1:10 ⇒ 1.1, 1:01 ⇒ 1.01
| Aggregation time | Time Minutes |
| (Cumulative total) | Time Minutes） |
| (Negative cumulative total) | Time Minutes） |
When entering values with the "Hours/Minutes" separation selected, decimal places are truncated.
I have only performed a simple check. I make no guarantees regarding the results.
I fixed an error in the output of negative results. I’ve simplified the input for hours and minutes.
I have only performed a simple check. I make no guarantees regarding the results.
I fixed an error in the output of negative results. I’ve simplified the input for hours and minutes.
No customer feedback for this calculation yet.