URGENT help with calculating time Thx
I Urgently need how to solve the following equation. I have a colum that displays date and time as such: May 02, 2006; 08:53 Have no problem removing the Date stuff and therefore only working with: 08:53 format I need to know how to calculate the full COLUMN when there are some 70 cells in the format hh:mm I need to display the total hours and minutes: I,e: Column A cell 1 08:30 all the way through to cell 70 10:21 Many many thanks Graeme -- gtech ------------------------------------------------------------------------ gtech's Profile: http://www.excelforum.com/member.php...o&userid=20333 View this thread: http://www.excelforum.com/showthread...hreadid=539205 |
URGENT help with calculating time Thx
Format column B as time, and in B1 add =--MID(A1,FIND("; ",A1)+2,99), then
copy down. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "gtech" wrote in message ... I Urgently need how to solve the following equation. I have a colum that displays date and time as such: May 02, 2006; 08:53 Have no problem removing the Date stuff and therefore only working with: 08:53 format I need to know how to calculate the full COLUMN when there are some 70 cells in the format hh:mm I need to display the total hours and minutes: I,e: Column A cell 1 08:30 all the way through to cell 70 10:21 Many many thanks Graeme -- gtech ------------------------------------------------------------------------ gtech's Profile: http://www.excelforum.com/member.php...o&userid=20333 View this thread: http://www.excelforum.com/showthread...hreadid=539205 |
URGENT help with calculating time Thx
Do you mean that you want to add up (sum) all the hours and minutes
from this column? I'm not sure why you would want to do this, but you could enter this formula somewhe =sum(A1:A70) and then select the cell and Format | Cell | Number (tab), scroll down to Custom and enter [h]:mm as the format. This will give you total hours in a form like 37:55 (i.e. it does not wrap at 24 hours) I hope this is what you want - post back if not. Pete |
All times are GMT +1. The time now is 08:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com