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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

converting time

Status
Not open for further replies.
chris100

chris100

Technical User
Jan 9, 2001
7
US
How do I convert time? Example 11:30 to 1130. How can it be caculated to show time spent from one point to another. Example: Patient enters the hospital at 7:00 am. Is admitted to the ICU unit at 9:00 am and goes back to the floor at 10:00 am the next day.
 
Sort by date Sort by votes
Lookup the datediff finction. It permits a number of intervals of date/time to be retrieves form the two dates.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cimoli
  • Locked
  • Question
Best password method with time factor
Replies
3
Views
431
cimoli
cimoli
v5652
  • Locked
  • Question
Ribbon icons missing each time when MS Windows 10 update
Replies
0
Views
350
v5652
v5652
EM1107
  • Locked
  • Question
populate a column with time from other column.
Replies
1
Views
334
Andrzejek
Andrzejek
dik
  • Locked
  • Question
Access and Time 1
Replies
2
Views
139
dik
dik
kopy
  • Locked
  • Question
Converting Phone Number Formats 3
Replies
5
Views
213
kopy
kopy

Part and Inventory Search

Sponsor

Back
Top