# Am trying to make a time sheet and having problems with a formula.

1. ## Am trying to make a time sheet and having problems with a formula.

can't figure formula to calculate time accurately. Can anyone help

2. ## Re: Am trying to make a time sheet and having problems with a formula.

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!
==============================================

"godnight" <godnight@discussions.microsoft.com> wrote in message
news:EEB72780-0B3C-48F5-A012-1E6276C1769C@microsoft.com...
> can't figure formula to calculate time accurately. Can anyone help
>

3. ## Re: Am trying to make a time sheet and having problems with a form

OR; look up in the webside templates and rip the formulas there, but i have
another Q.: how do i set a pause time into the formula:
=if((or(G7="";E7=""));0;if((E7<E7);((G7-E7)*24)+24;(G7-E7)*24))

"Ragdyer" skrev:

> 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!
> ==============================================
>
>
>
> "godnight" <godnight@discussions.microsoft.com> wrote in message
> news:EEB72780-0B3C-48F5-A012-1E6276C1769C@microsoft.com...
> > can't figure formula to calculate time accurately. Can anyone help
> >

>
>

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

#### 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