Re: Timesheet - I can't figure out how to do this!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: RagDyeR (ragdyer_at_cutoutmsn.com)
Date: 02/06/05 

Date: Sun, 6 Feb 2005 09:36:52 -0800

Start time in A1,
End time in B1,
Enter this formula in a cell formatted as "General" or "Number":
=(B1-A1+(B1<A1))*24*AND(A1<>0,B1<>0)

Both A1 and B1 must have times entered for this to work.

This will also work when the times span across midnight. 

-- 
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"M.R.S." <nospam@nospamthankyou.com> wrote in message
news:jjsNd.295$504.45358@news20.bellglobal.com...
Hi all,
I'd like to create a simple time sheet that calculates the amount of hours
I've worked in a day.
ex:
Date        Time IN    Time OUT    Total Hours
01/01/01    9:00AM    5:00PM        8
And so on for the week, and then have a total at the bottom for total hours
(that part is easy enough).
I've seen this done before.
Better yet, if I could figure out how to enter this data on my Visor PDA and
merge it into excel, that would be excellent.
Any suggestions?!?
Thanks.

Relevant Pages

  • RE: Patch Amounts
    ... > on the total amount of patches, hotfixes etc etc released by Microsoft for ... > This correspondence is for the named person's use only. ... > notify the sender. ... > expressly, and with authority, states them to be the opinions of SIFT Pty ...
    (Security-Basics)
  • Patch Amounts
    ... I am currently researching the amount of patches released by vendors for ... different operating systems. ... This correspondence is for the named person's use only. ... notify the sender. ...
    (Security-Basics)
  • Re: Bat Man Movie is for Morons!
    ... It's the same amount of AAAAARRRRGGGGGGHHHHH! ... He didn't think the bottom ones were going ... them one at a time because in both cases, the main nerve running ...
    (rec.arts.tv)
  • Re: Can you summarize a katlanis?
    ... the chase, no real meat, no bottom line, and I have always looked at the ... (Not that there aren't any female lawyers, but it looks like that would ... amount to mishkav zachar.) ... was Tamar a katlanit? ...
    (soc.culture.jewish.moderated)
  • Re: Commissions and lookup table
    ... Please keep all correspondence within the NewsGroup, ... I sell items on consignment and collect commission on a sliding scale. ... I have sheet 1 as follows: ... I thought that I could do a lookup formula where the commission amount ...
    (microsoft.public.excel.misc)