Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating time differences...with a twist

Status
Not open for further replies.
bosun

bosun

Technical User
Feb 14, 2002
20
US
I have to calculate system down time for a helpdesk application that I am designing. The down time will be the number of business hours between when the system went down and when service was restored.

I have the following information to start with:
DateSysDn
TimeSysDn
DateSysUp
TimeSysUp

Business hours are: M-F 07:00 - 19:00 Sat 07:30 - 17:00

I know I will have to create a function to do this, but I am a little lost at the moment.
 
Status
Not open for further replies.

Similar threads

cimoli
  • Locked
  • Question
Best password method with time factor
Replies
3
Views
280
cimoli
cimoli
EM1107
  • Locked
  • Question
populate a column with time from other column.
Replies
1
Views
206
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
4K
Andrzejek
Andrzejek
v5652
  • Locked
  • Question
Ribbon icons missing each time when MS Windows 10 update
Replies
0
Views
248
v5652
v5652
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
466
atadbitslow
atadbitslow

Part and Inventory Search

Sponsor

Back
Top