| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculate time, but if less then hrs, end result must be 1 hrs
Hi everybody!
I need to calculate time but if the difference is less then 1 hrs, end result must produce minimum of 1 hrs, and if difference is greater then an hrs or minutes, that should be displayed, how do I do this? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Calculate time, but if less then hrs, end result must be 1 hrs
Hi
With start time in A1 and end time in B1 =MAX(TIME(1,0,0),B1-A1) -- Regards Roger Govier "Shariq" wrote in message ... Hi everybody! I need to calculate time but if the difference is less then 1 hrs, end result must produce minimum of 1 hrs, and if difference is greater then an hrs or minutes, that should be displayed, how do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Currency to Text | Excel Worksheet Functions | |||
| VBA | Excel Worksheet Functions | |||
| time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| Calculate difference in time spanning a day, during office hours o | Excel Discussion (Misc queries) | |||
Linear Mode
