Hours: the number of minutes you want to add to time. It must be a positive whole number. If it is negative, the formula returns an error value #NUM!, if it is decimal number, such as 30.1, it reckons 30.1 as 30.
This comment was minimized by the moderator on the site
Hello and thank you for all the info provided.
With all due respect, someone needs to proofread your page, for there are several inconsistencies such as:
(right off the bat...)
Start_time+TIME(0,minutes,0)
Arguments
Start_time: ...
Hours: the number of...
Hours? Shouldn't it be TIME?
For example, there is a time in cell B12, and the number of minutes you want to subtract is displayed in cell C13, please use below formula:
=MOD(B12-TIME(0,20,0),1)
Or
=MOD(B13-TIME(0,C12,0),1)
Why did B12 become B13?
Where is C13 used?
These are two discrepancies in just one example.
Generally speaking, it does not allow the negative time in Excel
it???
There are 1440 minutes in a day, and one minute is 1/1440 day.
There are 1440 minutes in a day, so... or therefore,...
It seems you are hiring illegals who do not speak English all that well to write your material.
點擊下載示例文件
