Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells with time format and calculating the diffrence | New Users to Excel | |||
Calculating Time difference based on a condition | Excel Discussion (Misc queries) | |||
Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
Calculating negative time & creating scrol bars for fixed size txt box. | Excel Discussion (Misc queries) | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions |