Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TIME CALCULATION
I HAVE EXCEL SHEET TO CALCULATE TIME FOR WORKING HOURS, USEING FROM TO AND TOTAL TIME AS FOLLOWING:
FROM (A2), TO (B2) , TOTAL (C2) SHIFT HOURS FROM 06:00AM TO NEXT DAY 06:00AM AS 24HRS FORMAT CELL THE PROBLEM IS AFTER PASSING 24:00 MIDNIGHT (FROM 01:00AM TO 06:00AM) TOTAL IS NOT SHOWING BECAUSE ITS LESS THAN 24. PLEASE HELP. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TIME CALCULATION
"FEVOOO" wrote:
I HAVE EXCEL SHEET TO CALCULATE TIME FOR WORKING HOURS [....] FROM (A2), TO (B2) , TOTAL (C2) SHIFT HOURS FROM 06:00AM TO NEXT DAY 06:00AM AS 24HRS FORMAT CELL THE PROBLEM IS AFTER PASSING 24:00 MIDNIGHT (FROM 01:00AM TO 06:00AM) TOTAL IS NOT SHOWING BECAUSE ITS LESS THAN 24. First, the format of the cell does not matter. Second, to avoid the problem with computing negative time, use the following formula: =B2-A2+(A2B2) formatted as Time or whatever you want. |
#3
|
|||
|
|||
Quote:
=IF(B2<A2,(B2+1)-A2,B2-A2) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TIME CALCULATION
Hi,
or try: =MOD(B2-A2,1) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TIME CALCULATION
On Sunday, December 23, 2012 11:37:22 AM UTC+3, joeu2004 wrote:
"FEVOOO" wrote: I HAVE EXCEL SHEET TO CALCULATE TIME FOR WORKING HOURS [....] FROM (A2), TO (B2) , TOTAL (C2) SHIFT HOURS FROM 06:00AM TO NEXT DAY 06:00AM AS 24HRS FORMAT CELL THE PROBLEM IS AFTER PASSING 24:00 MIDNIGHT (FROM 01:00AM TO 06:00AM) TOTAL IS NOT SHOWING BECAUSE ITS LESS THAN 24. First, the format of the cell does not matter. Second, to avoid the problem with computing negative time, use the following formula: =B2-A2+(A2B2) formatted as Time or whatever you want. Thank you so muuuuuch, its working perfectly :) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TIME CALCULATION
On Sunday, December 23, 2012 3:51:47 PM UTC+3, Spencer101 wrote:
FEVOOO;1608199 Wrote: I HAVE EXCEL SHEET TO CALCULATE TIME FOR WORKING HOURS, USEING FROM TO AND TOTAL TIME AS FOLLOWING: FROM (A2), TO (B2) , TOTAL (C2) SHIFT HOURS FROM 06:00AM TO NEXT DAY 06:00AM AS 24HRS FORMAT CELL THE PROBLEM IS AFTER PASSING 24:00 MIDNIGHT (FROM 01:00AM TO 06:00AM) TOTAL IS NOT SHOWING BECAUSE ITS LESS THAN 24. PLEASE HELP. Try this in C2: *=IF(B2<A2,(B2+1)-A2,B2-A2)* -- Spencer101 yeeeees, I was tring all the night fo IF formula appreciate |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TIME CALCULATION
On Sunday, December 23, 2012 4:46:19 PM UTC+3, Claus Busch wrote:
Hi, or try: =MOD(B2-A2,1) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 thnaks alot for your efforts |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA time calculation | Excel Programming | |||
Stop time - start time calculation | Excel Worksheet Functions | |||
Time calculation (Subraction of Idle Time) | Excel Discussion (Misc queries) | |||
Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
time calculation with military time | Excel Worksheet Functions |