Results 1 to 3 of 3

Need formula dealing with time, hours & minutes

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2008
    Location
    West Palm Beach
    MS-Off Ver
    2007
    Posts
    41

    Smile Need formula dealing with time, hours & minutes

    I've got a worksheet that deals with dates and time. Similar to a checkbook, I need to take the balance and subtract what's taken from that. But the writer copied this from another software program and it's in this format. How do I convert it to a time format? Or is that what I really need? Right now the taken and balance are both in a general format. I just need to know on any of the given days what the balance of this person's time was in hours and minutes. Thanks for any assistance you may be able to give. Excel 2007. BTW, I don't really know how to write code.


    Date	       Source	                Taken	Balance
    1/1/2009	       Balance Fwd		                480h00
    1/5/2009	       Timekeeping Usage	1h25	
    1/22/2009	       Timekeeping Usage	10h00	
    1/23/2009	        Timekeeping Usage	7h00
    Last edited by shg; 02-01-2010 at 02:29 PM.

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