Count the minutes per day...

[itsupport]

Hi

I have a sheet that timestamps the start and end of a task the user does.
In the last col it states mins that the person spent doing the task.

What i would like to do is reflect the total amount of mins in a cell above...but not for the whole sheet, just for TODAY().

Im not quite sure how to start this off but i have a TODAY() cell and two rows with a start and end time (in day/date hour min format).

I have tried a sumif but it doesnt seem to work out for me!

 

[barry houdini]

If you have timestamp in column A and minutes in D try

=SUMPRODUCT((INT(A2:A1000)=TODAY())+0,D2:D1000)