Calculate total time(hours/minutes) from text/custom format column

[Steve Allen]

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

 

[muddan madhu]

col A start time
col B end time

in Col C =B1-A1 | custom format | [hh]:mm

 

[David Biddulph]

=(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.

 

[Steve Allen]

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.

col A start time
col B end time

in Col C =B1-A1 | custom format | [hh]:mm

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

 

[Steve Allen]

Thanks, strange that it worked this time but I'm glad it did and thanks again.