Time Conversion Explanation

[KuraiChikara]

Hello,
I had a question about what a particular time conversion is called if it's called anything at all.

Example:
The formula I'm using is
=((A2*60)+B2)/60

If your children did homework for 4 hours and 30 mins. That can be converted to 4.5 or 4.50
If your children watched TV for 1 hour and 26 mins. That can be converted to 1.43
If your children played outside for 3 hours and 4 mins. That can be converted to 3.07

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Mins[/TD]
[TD="align: center"]Converted[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]3.07[/TD]
[/TR]
</tbody>[/TABLE]

My question is, is there a name for the time conversion? Or is it simply time represented in decimal form?

 

[JoeMo]

In your examples you are converting time in hours and minutes to hours - 4 minutes being 0.066666 ... hours.

 

[Rick Rothstein]

My question is, is there a name for the time conversion? Or is it simply time represented in decimal form?

As far as I know, it is simply known as expressing the time in hours or, if you someone who is "picky", decimal hours.

 

[KuraiChikara]

Thank you for that, that helps out. I've been doing that time conversion for years and recently ran into someone who needed it explained. I advised them "time represented in decimal form." But that wasn't good enough.

 

[Rick Rothstein]

Thank you for that, that helps out. I've been doing that time conversion for years and recently ran into someone who needed it explained. I advised them "time represented in decimal form." But that wasn't good enough.

As far as I am concerned, it should have been.

 

[shg]

As far as I am concerned, it should have been.

Well ... Excel date/time is already in decimal time -- decimal days. I think the clarification is appropriate.

 

[KuraiChikara]

I'm following up on my own thread because I found the answer I was looking for.

My fellow posters in this thread explained that my examples: IE 1 minute is represented as 0.02, is simply representing ALL time as an hour or "decimal hours." However, there is a name for it. It's called "The 100 Minute Clock." And if you Google it in images, you will find charts that represent what I was explaining. I've been using it for years, I just didnt know that there's an actual name for it and someone else might need this information too. Now I have a name and an explanation of it's function IE" The 100 Minute Clock can represent all time as a fraction/decimal hour."

 

[SpillerBD]

As far as I am concerned, it should have been.

I agree. Only some archaic history buff would note the possible confusion.