Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2005
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Time Calculation (Excel 2003)

    In cell A1 I have starting time of 9:00 AM. In cell B1 I have ending time of 10:30 AM. In cell C1 I need to come up with 1:30 Hrs (time the person worked). What formula do I need in cell c1? Thanks....

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Time Calculation (Excel 2003)

    =B1-A1

    Format C1 as [h]:mm to display the elapsed time.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •