Wednesday 1 June 2016

Convert Days to Hour or Days to Minute :


Convert Days to Hour or Days to Minute :

Excel consist a function called CONVERT function. By using CONVERT function you could convert the days into hours or days into minute or hours into minutes or minutes into seconds or hours into seconds or many more.

=CONVERT(A2,"day","hr") : Days into Hours
=CONVERT(A2,"day","mn") : Days into Minutes





Thanks

No comments:

Post a Comment