Above Function

[davidvikings198]

Hi All,

I have the following information in a table:

Sys	if(IsNull(above(Sys)),0,Sys-Above(Sys))
8/24/2018 8:27	0
8/24/2018 8:51	0
8/24/2018 8:51	0
8/24/2018 8:59	0
8/24/2018 9:32	0

I have the formula I am using where I want a running total but it is not working.  I would like it to show as time like:

00:00:00

00:00:09

00:00:01

00:00:08

00:00:33

I hope this makes sense.  All suggestions would be helpful.

David

[petter]

It works fine for me:

Are you sure that the Sys field is really a date field? If the values in the Sys field is not accepted as dates they will be text and they might look ok in a table but calculations with them will not work.

[petter]

Here with a "running total":

[davidvikings198]

Thank you Petter.  I did not realize I posted it in two places.  Was late and must have typed the add wrong.  Anyways I thought I was correct.  I am checking if it is a true date field but mine is now showing 00:00:00 which makes me think it is a text field. 

David