| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time Code
Could I please get some advise on a code for time, I have a shift that
starts at 19:00 and this person finishes at 07:00 the next day. How do I write the code as the (07:00-19:00) e4-c4 does not calculate. Thanks again Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time Code
Hi Greg
=E4-C4+(E4<C4) HTH. best wishes Harald "Greg Brow" skrev i melding ... Could I please get some advise on a code for time, I have a shift that starts at 19:00 and this person finishes at 07:00 the next day. How do I write the code as the (07:00-19:00) e4-c4 does not calculate. Thanks again Greg |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time Code
one mo
=MOD(C4-E4,1) Note that both Harald's and this one will work with any two times that are within 24 hours of each other. -- Regards, Tom Ogilvy "Harald Staff" wrote in message ... Hi Greg =E4-C4+(E4<C4) HTH. best wishes Harald "Greg Brow" skrev i melding ... Could I please get some advise on a code for time, I have a shift that starts at 19:00 and this person finishes at 07:00 the next day. How do I write the code as the (07:00-19:00) e4-c4 does not calculate. Thanks again Greg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time with VBA code | Excel Discussion (Misc queries) | |||
| Time code | Excel Discussion (Misc queries) | |||
| Run-time error from my code | Excel Programming | |||
| Same VBA code, different run time | Excel Programming | |||
| Code runs every other time | Excel Programming | |||
Hybrid Mode
