Time can be a bit annoying in excel i think you might have to add the 5minutes in milliseconds to get the desired result but i am not completly sure. There are a load of great tutorials on this if you google Time calculations formaula excel you will get loads, heres a few examples
|
Conditional formatting formula excel Excel cell color change formula Excel cell text named range value Excel cell type vba Excel cell value based on a condition if loop Excel current time formula Excel formula if cell has data in in then equals 1 Excel formula if cell is blank number is 1 Excel pasting with formula one cell to another cell in same work sheet Excel vba formula in cell equals blank How do i hide a formula on an excel cell How do i populate a form with excel cell data How to make an excel cell blank using an if function How to make call to cell through internet I can't make formula between two sheets in excel 2007 Inserting actual date into excel cell Pasting excel formula one cell to previous cell in same sheet and same table Who do i only show a value in a excel cell if <0