Originally Posted by
joeu2004
You don't seem to understand.
If =TIME(0,MINUTE([@[Due Time]]),0)*1440 works for you, so should simply =MINUTE([@[Due Time]]). Both should return the integer 4 when the time is 19:04, for example.
When I tried the latter the first time, I got an inexplicable syntax errors. But that is simply because I do not know how to work with table object references.
When I tried it again, replacing your formula in column B, both formulas do indeed work if I also change the cell format.
That is, initially Excel displays 00:00 for both formulas. That is not "all zeros"; it is simply 00:00 time of day.
When I format as General, I do indeed see the integer 4.
So you should use simply =MINUTE([@[Due Time]]).
Bookmarks