Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Taking 1600-2400 and Converting to Time in different cells
Okay here is my issue.
I have the 1600-2400 in A1 now in B1 I want 1600(Start Time) to be a time value And in C1 i want 2400(End Time) to be a time value Then in D1 i want to find out the total hours, in this case 8 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Taking long time to save file to sub folder | Excel Discussion (Misc queries) | |||
Excel Taking Long TIme to Start | Excel Discussion (Misc queries) | |||
Row/Column Delete taking longer time | Excel Discussion (Misc queries) | |||
time format not taking new entry | Excel Discussion (Misc queries) | |||
Taking data from another worksheet and converting | Excel Worksheet Functions |