| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i subtract a half hour from a time when 8 hrs.
I want a spread sheet that will calculate the hours and min between two times
and when the hours worked are greater than 8 i want to subtract a half hour. I have =IF(((INT(B6-A6)*24)).*),(INT((B6-A6*24)-0.5),(INT((B6-A6*24))) when B6 is the finish time and A6 is the start time the formula i have now only shows me the hours worked and i need the exact hours and min. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert time to Half Hour inverval | Excel Discussion (Misc queries) | |||
| How do I round time down to the nearest half hour? | Excel Worksheet Functions | |||
| Convert Time To Half Hour - Pt 2 - OOPS! | Excel Discussion (Misc queries) | |||
| Calculate time difference to the half hour | Excel Worksheet Functions | |||
| how do you subtract military time? example 12:00 - 07:00 = 5 hour. | Excel Worksheet Functions | |||
Threaded Mode
