I used to know how to do this but it has completely slipped my mind. I have to cells ex. a1 and a2. I want time values in these cells ex. a1=5:30 and a2-6:00 now i have a cell a3 a3 that have the difference but i dont need it in the :30 format i need it in .5 format , how do i do this ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
EXCEL TIME TO DECIMAL CONVERSION
- Thread starter lashwarj
- Start date
- Status