I am struggling to find an answer and hope you can help. Is there a way to
convert time in HH:MM:SS (or just HH:MM) to a number in Excel? For example:



135:30:00
?

140:48:12
?






In this example I would like the first ? to reflect 135.5 while the second
would be something along the lines of 140.8. Can I create a formula that
would do this for me in a table full of times? Please advise.

see:

http://www.cpearson.com/excel/latlong.htm

same logic works for hours as degrees
--
Gary''s Student - gsnu200719


"CDA" wrote:

> I am struggling to find an answer and hope you can help. Is there a way to
> convert time in HH:MM:SS (or just HH:MM) to a number in Excel? For example:
>
>
>
> 135:30:00
> ?
>
> 140:48:12
> ?
>
>
>
>
>
>
> In this example I would like the first ? to reflect 135.5 while the second
> would be something along the lines of 140.8. Can I create a formula that
> would do this for me in a table full of times? Please advise.
>

Would it be possible to show me how this would look on one of the examples?

Thanks so much for this reference I really appreciate it!

"Gary''s Student" wrote:

> see:
>
> http://www.cpearson.com/excel/latlong.htm
>
> same logic works for hours as degrees
> --
> Gary''s Student - gsnu200719
>
>
> "CDA" wrote:
>
> > I am struggling to find an answer and hope you can help. Is there a way to
> > convert time in HH:MM:SS (or just HH:MM) to a number in Excel? For example:
> >
> >
> >
> > 135:30:00
> > ?
> >
> > 140:48:12
> > ?
> >
> >
> >
> >
> >
> >
> > In this example I would like the first ? to reflect 135.5 while the second
> > would be something along the lines of 140.8. Can I create a formula that
> > would do this for me in a table full of times? Please advise.
> >