If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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
|
|||
|
|||
Start time in A1,
End time in B1, Enter this formula in a cell formatted as "General" or "Number": =(B1-A1+(B1A1))*24*AND(A10,B10) 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" wrote in message ... can't figure formula to calculate time accurately. Can anyone help |
#3
|
|||
|
|||
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((E7E7);((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+(B1A1))*24*AND(A10,B10) 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" wrote in message ... can't figure formula to calculate time accurately. Can anyone help |
Thread Tools | |
Display Modes | |
|
|