| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time formulas
I went to make a schedule for printing out for manual fill in. I changed the format of column A to time. I entered the first time in A3 A3 6:00am A4 =A3+:30 didnt work A4= A3+30 didn't work A4=A3+.5 didn't work Those were just guesses. What's the right way? -- famdamly ------------------------------------------------------------------------ famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382 View this thread: http://www.excelforum.com/showthread...hreadid=517868 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time formulas
In A4 the formula is
=A3+(30/1440) .... where 1440 = 60 minutes x 24 hours. To Excel, a time such as 6:30 am is the fraction of a day. Each day is an integer number; a time during that day is the integer number plus a fraction. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| Time and motion chart | Charts and Charting in Excel | |||
| Can series tool change formulas over time when used to copy them | Excel Worksheet Functions | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
| formulas for employee time sheets | Excel Worksheet Functions | |||
Linear Mode
