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

Converting Time to minutes : 2:00:00 into 120 minutes?

Status
Not open for further replies.
CTOROCK

CTOROCK

Programmer
May 14, 2002
289
US
I'm in Office 2000, and I have two times, say 3:00 & 1:00. I subtract the two and get 2:00:00. How can I convert that into minutes to say 120 minutes? Any help apprecitated
Thanks!
Eric "The greatest risk, is not taking one."
 
Sort by date Sort by votes
I used (2:00:00) * 24
and it worked!
Thank you "The greatest risk, is not taking one."
 
Upvote 0 Downvote
I should've typed

(3:00-1:00)*24*60

sorry about the typo and the confusion
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
1K
remeng
remeng
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
915
strongm
strongm
EliseFreedman
  • Locked
  • Question
booking tool - all day time slots
Replies
3
Views
573
Andrzejek
Andrzejek
kris gersbach
  • Locked
  • Question
I’m importing a csv into a vfp curs
Replies
1
Views
246
Andrzejek
Andrzejek
feipezi
  • Locked
  • Question
Hoe to fix run time error 2147217900 (80040e14) syntax error in Order By clause 1
Replies
6
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top