Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

  #2   Report Post  
Posted to microsoft.public.excel.misc
via135
 
Posts: n/a
Default calculating total time


hi!

in C1:

=B1-A1

where endtime & start time in B1 & A1 respectively
and format C1 Custom [hh]:mm

-via135



bcamp1973 Wrote:
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?



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

  #3   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default calculating total time

Hi!

Just subtract the start time from the end time:

A1 = start time = 7:30 AM
B1 = end time = 5:45 PM

Format the cell as [h]:mm

=B1-A1

Returns 10:15

If the times might span past midnight use this formula:

A1 = start time = 10:00 PM
B1 = end time = 3:20 AM

=B1-A1+(B1<A1)

Returns 5:20

Biff

"bcamp1973" wrote
in message ...

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



  #4   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default calculating total time

Times in excel is just numbers so to get total time jus subtract

=B1-A1

where A1 is start and B1 end, if more than 24 hours use a custom format of

[hh]:mm


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"bcamp1973" wrote
in message ...

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



  #5   Report Post  
Posted to microsoft.public.excel.misc
bcamp1973
 
Posts: n/a
Default calculating total time


Perfect, thanks everyone!


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

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
Calculating time and pay in excel wobbleman Excel Discussion (Misc queries) 1 December 6th 05 11:59 PM
Calculating elapsed time andoh Excel Worksheet Functions 5 November 17th 05 12:31 PM
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 10:15 PM
Calculating effective time from start/end date+time Stefan Stridh Excel Worksheet Functions 8 November 27th 04 04:50 PM


All times are GMT +1. The time now is 05:46 PM.

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"