Hi...new to any and all message boards.
Need to be able to take a column that has times entered in military format (7:10:56) and have the cell at the bottom give the amount of total time in minutes (28 minutes).
Is there a formula to help me do that?
Thanks in advance for any help with this problem.
Last edited by bustech; 02-15-2013 at 02:17 PM.
to change to minutes use
=cell*24*60 and change format to a number
OR
=SUM(Cells)*24*60
EDIT: As I posted, noticed that it was solved!
Last edited by Kevin UK; 02-17-2013 at 07:13 AM.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks