How to create a minute counter for SLA reports?!

[bass_junkie123]

Morning Excel guru's!!

Got a quick one, if I may!

I'm trying to create more accurate and 'up to date' SLA reports for my team and was wondering if there was a way to make a 'time in minutes' cell count up every min?

Basically the way it is at the moment is the report is run in the morning and the same time stays to each item all day, so if an item is 'in time' at 11.30am it might not be at 3pm but it would still show it to be OK on the report.

Basically I want those times to increase every min so that they know how long they ACTUALLY have to complete it!

I don't mind if it's completely live or whether you need to press a button to update it!

Any help on this would be much appreciated!

Thanks!

[bass_junkie123]

Bump!

Is this not just a simple thing then??

[bass_junkie123]

Am I in the wrong section, guys??

[TYork]

Try using the now() function. So for instance:

Now() - [some time] = [difference]

To update you would need to refresh the document. That's the least sophisticated and easiest way to approach it I believe.

[bass_junkie123]

Cheers mate!

But sorry I'm obviously a spacker and don't quite understand!

Say I've got 5420 mins and I wanted to count this up indefinitely, how would the formula look?

Sorry, I'm really no good on Excel and only know the very basic things!

[rwgrietveld]

if this is valid

I don't mind if it's completely live or whether you need to press a button to update it!

then we can take the simple approach.

Put this in A1: = Now() Press F9 when you have the cursor in the cell (formula bar), so the current date/Time is set statically (non-volitile) in A1
Put this in A2: = Now() Press Enter normally so the current date/Time is set dynamically (volitile)
Put this in A3:= A2-A1

Right Click Cell A3, format cells custom mm:ss
Return to the sheet

Now when you press F9 the time is updated.

[TYork]

Check out the attached and let me know if it helps. To update the time all you have to do is press F2 and then Enter. This will update all now() formulas in the workbook.

[bass_junkie123]

if this is valid then we can take the simple approach.

Put this in A1: = Now() Press F9 when you have the cursor in the cell (formula bar), so the current date/Time is set statically (non-volitile) in A1
Put this in A2: = Now() Press Enter normally so the current date/Time is set dynamically (volitile)
Put this in A3:= A2-A1

Right Click Cell A3, format cells custom mm:ss
Return to the sheet

Now when you press F9 the time is updated.

Thanks for that mate!! That should work!!

But how can I get it to display mm:ss? I can only find hh:mm:ss? Or even better to just display the mins?

Thanks again!!

[bass_junkie123]

Ah found it under custom!!

Is there a way to 'just' get the mins, though?? Thanks!

[bass_junkie123]

Hmm, OK... let me explain a little better! The SLA looks something like:

Ref Name Starting SLA Current SLA
NHA Pete 5258
HLK John 4587
PLA Mike 4558

That number is the time in mins that the item already had on it when the report was ran at 9am, the column next to it is what the CURRENT SLA time should be, so say at 11am, 2 hours later that box should be filled with the number on the left plus 120 mins!

What's the simplest way of achieving this?

Thanks for all your help,

I must say I'm quite enjoying fiddling with Excel!!

[bass_junkie123]

Also noticed that it goes back to 1 after 60??