| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time around midnight
If I am reading what you want correctly, try
=if(mod(time_entry,1)<0.5,hour(time_entry)+minute( time_entry)/100,-hour(1-mod(time_entry,1))-minute(1-mod(time_entry,1))/100 "Mai-Britt" wrote: How do I convert time of day to time according to midnight? Ex. 21:37 to -2,23? Or 02:43 to +2,43? Midnight is defined as 0. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating time past midnight. | Excel Discussion (Misc queries) | |||
| subtraction off time after midnight | Excel Worksheet Functions | |||
| Calculating Time Past Midnight | Excel Worksheet Functions | |||
| Calculating time interval (some across midnight) | Excel Worksheet Functions | |||
| Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
Threaded Mode
