time calc for 24hr clock help needed! (1 Viewer)

[Cara]

Like RVP's problem - posted 29th Jan - I need to calculate interval between 2 different 'times' - Time of Birth and Time of Medication (time diffs are somewhere between 2 hours and 3 minutes). Neo's response was very useful as it overcomes negative values but as I need to do some basic stats on the results (mean, median etc) I need to have the results in minutes. I tried to use FionaC's formula but it didn't seem to work - came back with 0.00972 instead of 14minutes. I'd really appreciate some help! Thanks for reading!
Cara

 

[David R]

You can use Format() surrounding your calculations to get it all in one specified format (i.e. all in minutes ranging from 120 to 3). Look it up in the help, but I believe the switch is "n".

HTH,
David R