LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
bcamp1973
 
Posts: n/a
Default calculating total time


I have two fields "start time" and "end time" for tracking my time on
projects. on each line next to those fields i'd like to add a "total"
field that automatically calculates the total time in hours and
minutes. I thought there might be a function for this already, but i'm
not finding it in the help files...any suggestions?


--
bcamp1973
------------------------------------------------------------------------
bcamp1973's Profile: http://www.excelforum.com/member.php...o&userid=32268
View this thread: http://www.excelforum.com/showthread...hreadid=539940

 
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 time and pay in excel wobbleman Excel Discussion (Misc queries) 1 December 6th 05 10:59 PM
Calculating elapsed time andoh Excel Worksheet Functions 5 November 17th 05 11:31 AM
Calculating Pay based on time of day hrs worked scarlett1 Excel Worksheet Functions 4 July 6th 05 11:45 PM
Calculating tvl time in Excel 2000 Rev.9.2720 Brandi Excel Worksheet Functions 5 January 27th 05 09:15 PM
Calculating effective time from start/end date+time Stefan Stridh Excel Worksheet Functions 8 November 27th 04 03:50 PM


All times are GMT +1. The time now is 08:20 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"