Software

Ask something
Discussion Locked

Excel 2000 Time??

0 helpful
5 replies

by suzie_q

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Does anyone know how to convert hours and minutes derived from a formula, into total minutes?? For example, my work day after taking out the lunch time is 9:20, Nine hours and 20 minutes, or 560 minutes, is there a way to convert 9:20 to minutes??

5 replies

by mike_shimandle

Given cell E3 is where your calculation resides try this.
=((HOUR(E3))*60+MINUTE(E3))
Make sure you Format the cell to a General format.

This discussion is closed to new replies.