Microsoft excel problem

bluhat

Elite Member
Jr. VIP
Joined
Apr 26, 2011
Messages
2,248
Reaction score
260
Hello friends,

I think this not the right section about my question but I did not found the right section.
However, I have a problem with excel. I need to convert time. For example I need to convert 1:10 hrs and its result is 1.17 hrs. Please help me out this problem.

Please again i say this is Microsoft excel problem.
I am waiting for your good tips.

Thanks
 
Last edited:
To be honest, there are a lot of other places on the internet that could handle this a lot better than here, also Google has a search function, that can give you answers to questions like this sometimes. But, this is basic depending on how much excel you understand, how you have your data set up, and if you understand excel commands.

So if you have 1:10 in cell A1, then you could do this

=(A1-INT(A1))*24

where A1 is a cell containing a time value.

So, if A1= 1:10 it returns a value of 1.16667

Or, you could do a whole lot of other things, not sure what you're after, so good luck...
 
Last edited:
Back
Top