LinkBack URL
About LinkBacks
Hi everyone,
need to convert a number that contains data on hours and minutes (for example 2.2h) to only minutes. In this case 140min. Is there a formula for this ?
Hi everyone,
need to convert a number that contains data on hours and minutes (for example 2.2h) to only minutes. In this case 140min. Is there a formula for this ?
Maybe:
=INT(A1)*60+MOD(A1,1)*100
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Re: time unit convertion
hey, many thanks, works perfectly!
the formula should be justOriginally Posted by Kukainis
Hi everyone,
need to convert a number that contains data on hours and minutes (for example 2.2h) to only minutes. In this case 140min. Is there a formula for this ?
"=A1*60"
2.2h actually is 132 mins not 140 mins.
If it's a true decimal value the that would be the case but I was assuming from the example that it wasn't.
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks