Converting Hours:Minutes to Decimal
Hi Folks - I've got a mental block .... How can I convert the elapsed time
of 07:15 (seven hours and 15 minutes) to the decimal format 7.25 (seven and a quarter hours)? Thanks. -- Michael |
Converting Hours:Minutes to Decimal
=A1*24 format as general
-- Gary''s Student - gsnu200742 "Michael" wrote: Hi Folks - I've got a mental block .... How can I convert the elapsed time of 07:15 (seven hours and 15 minutes) to the decimal format 7.25 (seven and a quarter hours)? Thanks. -- Michael |
Converting Hours:Minutes to Decimal
Hi Folks - I've got a mental block .... How can I convert the elapsed time
of 07:15 (seven hours and 15 minutes) to the decimal format 7.25 (seven and a quarter hours)? Thanks. Multiply the cell your value is in by 24 (remember, the time part is the fraction of a 24-hour day). Rick |
All times are GMT +1. The time now is 11:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com