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
<colgroup><col style="width: 48pt;" width="64">
<tbody>
</tbody>
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
7.00 |
30.00 |
0.30 |
1.15 |
2.15 |
6.30 |
0.03 |
2.50 |
<colgroup><col style="width: 48pt;" width="64">
<tbody>
</tbody>
Thanks,