Convert Short Time to a number (seconds)

[Robert C]

This must have been answered before, but I can't find it by searching so sorry for the dumb question.

I input a time in hours and minutes in a field with a Short Time format. I would like then to convert this to seconds in a field with a number format so that I can total the seconds and then add them to the results of a calculated DateDiff control to get the grand total of time spent on a project.

Any help would be gratefully received.

Cheers

Rob

 

[llkhoutx]

Have you searched this site? I'm cerain that time conversion has been covered numerous time.

 

[MarkK]

MsgBox #12:00:01 AM# * 24 * 60 * 60