| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I caculate 24 hour military times
Bob,
I should learn how to use Boolean instead of IF( ). Case in point +(B21<A21)*..... If B21 = A21, there is no way to tell if it is the next day or the same day. I guess depending on the user's need, one may have to change the formula to =B21-A21+(B21<=A21)*2400 to reflect 2400 for the lapse of one day. Any comments? Epinn "Bob Phillips" wrote in message ... =B21-A21+(B21<A21)*2400 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Tom" wrote in message ... How can I caculate military times such as 1800 hours to 400 hours for a time sheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a formula to muliply hours times dollars per hour? | Excel Discussion (Misc queries) | |||
| How to I convert standard time to Military or 24 hour format? | Excel Discussion (Misc queries) | |||
| How do I sum times to get a total hour value? If I add up to 24 h. | Excel Discussion (Misc queries) | |||
| subtracting times using 24 hour clock | Excel Worksheet Functions | |||
| how do you subtract military time? example 12:00 - 07:00 = 5 hour. | Excel Worksheet Functions | |||
Threaded Mode
