Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 747
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate total pay from pay rate times hours and minutes Rufus Excel Discussion (Misc queries) 5 May 1st 23 07:45 PM
calculating timesheet, time-in/time-out = total hours & minutes, . Steve Lindsay Excel Worksheet Functions 13 November 8th 06 04:45 PM
Custom Format for hours and minutes Paul D. Simon Excel Discussion (Misc queries) 4 September 16th 05 11:12 PM
How to sum a column of hours & minutes in format TEXT(C5-B5,"h:mm" nosam Excel Worksheet Functions 2 March 25th 05 05:09 PM
add column of minutes, show total in hours & minutes glider pilot Excel Worksheet Functions 1 December 30th 04 11:27 PM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"