Subtracting Two DateTime Fields

[GMAN33]

Hello,

I would like to subtract two datetime fields to get how long a process takes and would like to have the results come out like "0 hours, 2 minutes, 37 seconds" They are within the same table.

Any help on the formula would be appreciated

Thanks

 

[GMAN33]

BINGO!!!!!!!!!!

Fantastic Work!!!!!

Double your pay!!!!

Thank you soooooo much for all of your hard work and efforts....It really means alot to me!!!!

Take care
GMAN

 

[GMAN33]

Naith,

They now want me to throw days in there as well. Can you help me with that? Than it is finished.

Thanks
GMAN

 

[Naith]

Throw in a days variable working off a value of 1440 (switch the hrs variable to use the remainder function), or see the LoadTime formula in thread149-480703.

 

[GMAN33]

Thank you again Naith for the fantastic work. It is nice that you are always willing to help. We all appreciate it!!!

Take care
GMAN