pochonerd Posted February 27, 2005 Share Posted February 27, 2005 Need to calculate Hours and MInutes elapsed during two events. For example I have four fields: EntryDate, Entry Hour, ExitDate and Exit Hour, and what I need to know what is the amount of time during this two events. What kind of calculation should I use, since this can ocurr in different dates or weeks? Thansk in Advance@ Link to comment Share on other sites More sharing options...
comment Posted February 27, 2005 Share Posted February 27, 2005 (ExitDate - EntryDate) * 86400 + Exit Hour - Entry Hour Set result to Time. Link to comment Share on other sites More sharing options...
pochonerd Posted February 28, 2005 Author Share Posted February 28, 2005 THANKS NEWBIE! Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.