Results 1 to 8 of 8

Excel 2007 : Calculations on a cell containing hours and minutes

Threaded View

  1. #1
    Registered User
    Join Date
    07-06-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Calculations on a cell containing hours and minutes

    I'm working on a time sheet application. I have the start time and end time. I also have a place for "non billable time". That would include lunch or any other time off.

    I want to be able to calculate the time difference between start time and end time AND subtract the non-productive time from it.

    I have no problem with the calculation of hours and minutes between the start time and the end-time. But when I try to use the non-billable time in any calculation, it gives me a #VALUE error.

    Can anybody help?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1