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

Formula to change hrs and mins to just mins 1

Status
Not open for further replies.
advox1

advox1

Technical User
Nov 28, 2003
26
0
0
GB
Hi

Does anyone know a formula which will convert a time which is hours and minutes to just minutes?

ie 1:20 to 80

Thanks

Joanne
 
Sort by date Sort by votes
format as [mm]

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
155
SkipVought
S
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
125
SkipVought
S
TomSalvato
  • Locked
  • Question
EXCEL-formula help 2
Replies
6
Views
102
TomSalvato
TomSalvato
Metzke
  • Locked
  • Question
How to Transfer Licence to New PC
Replies
11
Views
246
teknance
teknance
duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
525
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top