Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate total time(hours/minutes) from text/custom format column
I download a csv report that has two columns that I'd like to work with.
1-session start (custom format) "11/6/2008 16:59" 2-session end, same format, end of session may be in excess of 24 hours after session start. "11/8/2008 19:32". I would like the final column to express the total time in hours and tenths for billing. I have tried many suggestions but I can't make them work for me. I can send a sample of the csv or the spreadsheet in Excel 2002 to anyone that want's to help. I have Excel 2002. hot mail sallenss Thanks in advance Steve |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate total time(hours/minutes) from text/custom formatcolumn
col A start time
col B end time in Col C =B1-A1 | custom format | [hh]:mm On Dec 11, 10:39*am, Steve Allen wrote: I download a csv report that has two columns that I'd like to work with. 1-session start (custom format) "11/6/2008 16:59" 2-session end, same format, end of session may be in excess of 24 hours after session start. "11/8/2008 19:32". I would like the final column to express the total time in hours and tenths for billing. I have tried many suggestions but I can't make them work for me. I can send a sample of the csv or the spreadsheet in Excel 2002 to anyone that want's to help. *I have Excel 2002. *hot mail sallenss Thanks in advance Steve |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate total time(hours/minutes) from text/custom format column
=(B2-A2)*24 and format as number or general.
You said: "I have tried many suggestions but I can't make them work for me.", in which case it would have been helpful if you had told us what you'd tried and in what way these methods didn't work. -- David Biddulph "Steve Allen" wrote in message ... I download a csv report that has two columns that I'd like to work with. 1-session start (custom format) "11/6/2008 16:59" 2-session end, same format, end of session may be in excess of 24 hours after session start. "11/8/2008 19:32". I would like the final column to express the total time in hours and tenths for billing. I have tried many suggestions but I can't make them work for me. I can send a sample of the csv or the spreadsheet in Excel 2002 to anyone that want's to help. I have Excel 2002. hot mail sallenss Thanks in advance Steve |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate total time(hours/minutes) from text/custom format co
Thanks, it worked this time, I don't know why I had trouble with this except
I may have been using an older version of Excel when I last tried. "muddan madhu" wrote: col A start time col B end time in Col C =B1-A1 | custom format | [hh]:mm On Dec 11, 10:39 am, Steve Allen wrote: I download a csv report that has two columns that I'd like to work with. 1-session start (custom format) "11/6/2008 16:59" 2-session end, same format, end of session may be in excess of 24 hours after session start. "11/8/2008 19:32". I would like the final column to express the total time in hours and tenths for billing. I have tried many suggestions but I can't make them work for me. I can send a sample of the csv or the spreadsheet in Excel 2002 to anyone that want's to help. I have Excel 2002. hot mail sallenss Thanks in advance Steve |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate total time(hours/minutes) from text/custom format co
Thanks, strange that it worked this time but I'm glad it did and thanks again.
"David Biddulph" wrote: =(B2-A2)*24 and format as number or general. You said: "I have tried many suggestions but I can't make them work for me.", in which case it would have been helpful if you had told us what you'd tried and in what way these methods didn't work. -- David Biddulph "Steve Allen" wrote in message ... I download a csv report that has two columns that I'd like to work with. 1-session start (custom format) "11/6/2008 16:59" 2-session end, same format, end of session may be in excess of 24 hours after session start. "11/8/2008 19:32". I would like the final column to express the total time in hours and tenths for billing. I have tried many suggestions but I can't make them work for me. I can send a sample of the csv or the spreadsheet in Excel 2002 to anyone that want's to help. I have Excel 2002. hot mail sallenss Thanks in advance Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate total pay from pay rate times hours and minutes | Excel Discussion (Misc queries) | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Custom Format for hours and minutes | Excel Discussion (Misc queries) | |||
How to sum a column of hours & minutes in format TEXT(C5-B5,"h:mm" | Excel Worksheet Functions | |||
add column of minutes, show total in hours & minutes | Excel Worksheet Functions |