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

convert time to a number

Status
Not open for further replies.
balllian

balllian

MIS
Jan 26, 2005
150
GB
How is it possible to convert a time field to a number. The field is hh:mm:ss ie 00:02:30. I need this to be represented as 2.50.

Any help would be greatly appreciated.


 
Sort by date Sort by votes
How about:

Hour(TheTime) + (Minute(TheTime)/60)
 
Upvote 0 Downvote




Or even
[tt]
[TheTime] * 24
[/tt]
since Date/Time UNITS are days.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
453
serino
serino
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
260
dhookom
dhookom
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
331
dhookom
dhookom
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
603
combo
combo
supportsvc
  • Locked
  • Question
How to limit the number of records based on the quantity in a field? 1
Replies
8
Views
192
supportsvc
supportsvc

Part and Inventory Search

Sponsor

Back
Top