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

R

Ragdyer

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

stargaze

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Help with a formula for a Time Sheet. 1
Need formula for calculating time 2
IF validation for time totaling 2
Have the SUMIF result (formula) on a separate sheet/tab 2
Excel formula help for calculating freight. 2
Formula not being Friendly 3
Calculate end date and time 1

Top