| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating time without using military time
Hello my faithful saviours. I am here again asking for some assistance. I
have been working on and tweaking our time sheets and the one thing I cant seem to do is to find if it is possible to do the calculations without having to use military time. I want the employees to be able to just put the actual time instead of the military. Is this possible and how do I do it. I am sure it is an easy fix but nothing is easy for me. This is the currecnt code for daily hours worked minus lunch. =IF(C10=0, 8, IF(F10=0, " ", IF((SUM(((D10-C10)+(F10-E10))*24))<0, SUM(((D10-C10)+(#REF!-E10)+F10)*24+1), SUM(((D10-C10)+(F10-E10))*24)))) If anyone can assist me, I would greatly appreciate it. Thank you again. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating time without using military time
Before you go too much further, you better figure out where the #REF! comes
from and fix it. "Corkey" wrote: Hello my faithful saviours. I am here again asking for some assistance. I have been working on and tweaking our time sheets and the one thing I cant seem to do is to find if it is possible to do the calculations without having to use military time. I want the employees to be able to just put the actual time instead of the military. Is this possible and how do I do it. I am sure it is an easy fix but nothing is easy for me. This is the currecnt code for daily hours worked minus lunch. =IF(C10=0, 8, IF(F10=0, " ", IF((SUM(((D10-C10)+(F10-E10))*24))<0, SUM(((D10-C10)+(#REF!-E10)+F10)*24+1), SUM(((D10-C10)+(F10-E10))*24)))) If anyone can assist me, I would greatly appreciate it. Thank you again. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating time without using military time
And don't use a space " " in IF(F10=0, " ",
Use "" instead. Gord Dibben MS Excel MVP On Mon, 2 Nov 2009 10:24:01 -0800, Barb Reinhardt wrote: Before you go too much further, you better figure out where the #REF! comes from and fix it. "Corkey" wrote: Hello my faithful saviours. I am here again asking for some assistance. I have been working on and tweaking our time sheets and the one thing I can’t seem to do is to find if it is possible to do the calculations without having to use military time. I want the employees to be able to just put the actual time instead of the military. Is this possible and how do I do it. I am sure it is an easy fix but nothing is easy for me. This is the currecnt code for daily hours worked minus lunch. =IF(C10=0, 8, IF(F10=0, " ", IF((SUM(((D10-C10)+(F10-E10))*24))<0, SUM(((D10-C10)+(#REF!-E10)+F10)*24+1), SUM(((D10-C10)+(F10-E10))*24)))) If anyone can assist me, I would greatly appreciate it. Thank you again. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating time without using military time
Sorry, I did find the Ref error after I copied it. I did fix that and the ""
issue. Thank you for the advice on that. "Corkey" wrote: Hello my faithful saviours. I am here again asking for some assistance. I have been working on and tweaking our time sheets and the one thing I cant seem to do is to find if it is possible to do the calculations without having to use military time. I want the employees to be able to just put the actual time instead of the military. Is this possible and how do I do it. I am sure it is an easy fix but nothing is easy for me. This is the currecnt code for daily hours worked minus lunch. =IF(C10=0, 8, IF(F10=0, " ", IF((SUM(((D10-C10)+(F10-E10))*24))<0, SUM(((D10-C10)+(#REF!-E10)+F10)*24+1), SUM(((D10-C10)+(F10-E10))*24)))) If anyone can assist me, I would greatly appreciate it. Thank you again. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating time without using military time
(C8=0, 8, IF(F8=0, "", IF((SUM(((D8-C8)+(F8-E8))*24))<0,
SUM(((D8-C8)+($E$24-E8)+F8)*24+1), SUM(((D8-C8)+(F8-E8))*24)))) "Corkey" wrote: Hello my faithful saviours. I am here again asking for some assistance. I have been working on and tweaking our time sheets and the one thing I cant seem to do is to find if it is possible to do the calculations without having to use military time. I want the employees to be able to just put the actual time instead of the military. Is this possible and how do I do it. I am sure it is an easy fix but nothing is easy for me. This is the currecnt code for daily hours worked minus lunch. =IF(C10=0, 8, IF(F10=0, " ", IF((SUM(((D10-C10)+(F10-E10))*24))<0, SUM(((D10-C10)+(#REF!-E10)+F10)*24+1), SUM(((D10-C10)+(F10-E10))*24)))) If anyone can assist me, I would greatly appreciate it. Thank you again. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
| Is there an XLS function to convert std time to Military time? | Excel Worksheet Functions | |||
| Calculating Military Time | Excel Worksheet Functions | |||
| formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
| Show timesheet time in and out in regular time versus military tim | Excel Worksheet Functions | |||
Linear Mode
