Time calculation

[lonesomejubilee]

Hi

I'm trying to write a time card db, and I don't like the template, so I'm going to make my own. I need it to run 24 h ours so how would I write a calculation so if someone clocks in at 23:00 and out at 7:00 it will show as 8 hours instead of -16 hours?

Thanks...

Vandy

[RalphL]

Use TimeStamp instead of time. Use time for the result of you calculation. Or do you own calculations, timestamp is number of seconds.

[lonesomejubilee]

Will it still calculate past the date line?

[lonesomejubilee]

Thanks, one last question.... the timestamp calculated correctly, but I don't like the way it looks... having both the date and time... is there anyway to truncate it to just the time?

[transpower]

GetAsTime ( timestamp )