LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default Calculating hr/min format

I have a column where the time is listed in an hr/minute format (example: 11
h 30 min). There are a number of rows with this information and I need to
total the time used (with the format given) and am unsure how to accomplish
this. I'm hoping there would be a simple formula.

Thanks in advance.
 
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
Calculating Difference Between Two Times in General Format MGranger Excel Worksheet Functions 5 May 25th 09 05:34 PM
calculating time, overtime in excel [h]:mm format iamtaranicole Excel Discussion (Misc queries) 4 November 9th 07 05:19 PM
I format for date but it is calculating Tory Excel Discussion (Misc queries) 3 September 5th 06 01:25 PM
Cells with time format and calculating the diffrence MikeR-Oz New Users to Excel 11 January 3rd 06 10:11 AM
calculating with a time format cell Mahnaz Excel Worksheet Functions 1 December 13th 04 10:21 AM


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

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

About Us

"It's about Microsoft Excel"