LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 192
Default Calculating Hours and minutes

I am needing to calculate how long an item was used for using hours and
minutes.
Is there a formula or format that will let me do this.
The total will go into thousands of hours.
And i cannot have days or seconds, must only be hours and minutes in my
spreadsheet.

Can anyone help
 
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 number of hours and minutes Neville Excel Discussion (Misc queries) 6 May 13th 07 04:58 PM
calculating timesheet, time-in/time-out = total hours & minutes, . Steve Lindsay Excel Worksheet Functions 13 November 8th 06 03:45 PM
Calculating time, hours and minutes arrowpilot Excel Discussion (Misc queries) 1 October 21st 06 12:04 AM
Calculating and Adding Hours, Minutes, and Seconds in a CALL LOG EmanJR Excel Worksheet Functions 1 August 3rd 06 03:47 PM
calculating fees from hours and minutes tinytots Excel Worksheet Functions 2 November 19th 05 05:29 PM


All times are GMT +1. The time now is 03:10 PM.

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"