judejerrysalmon
New Member
- Joined
- Sep 24, 2016
- Messages
- 6
Dear all,
I have the duration data for more than 40000 rows in the number format. I need a method to convert the same into time format in excel. BY saying number format i mean 1 Hours & 45 minutes has been given as 1.45. I would like to have the same value 1.45 in the TIME format in excel so that i can sum or average the overall values correctly.
Sample data
[TABLE="width: 48"]
<colgroup><col style="width: 48pt;" width="64">
<tbody>[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"]7.00[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]30.00[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]0.30[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]1.15[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]2.15[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]6.30[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]0.03[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]2.50[/TD]
[/TR]
</tbody>[/TABLE]
Thanks,
I have the duration data for more than 40000 rows in the number format. I need a method to convert the same into time format in excel. BY saying number format i mean 1 Hours & 45 minutes has been given as 1.45. I would like to have the same value 1.45 in the TIME format in excel so that i can sum or average the overall values correctly.
Sample data
[TABLE="width: 48"]
<colgroup><col style="width: 48pt;" width="64">
<tbody>[TR]
[TD="class: xl63, width: 64, bgcolor: transparent"]7.00[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]30.00[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]0.30[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]1.15[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]2.15[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]6.30[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]0.03[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]2.50[/TD]
[/TR]
</tbody>[/TABLE]
Thanks,