How to get cells to calculate time?

		Microsoft Office Forums > Microsoft Excel > Excel
How to get cells to calculate time?

FAQ

Thread Tools

Display Modes

09-29-2006, 08:43 PM

Ziggy1

Novice

Join Date: Sep 2006

Location: Ont, Canada

Posts: 8

this will work as long as your hours stay with in one day

Format your Time Cells as Time and the cell with this formula as an Number format

=(EndTime - StartTime)/24

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
format cells to automatically place quotes around text	dirtleg	Excel	1	09-16-2008 01:52 PM
How to stop correcting zeroes in cells ?	kevin_ms	Excel	4	09-14-2008 10:08 PM
Nested if formulat to merge cells	cristi22	Excel	0	10-23-2006 08:28 AM
Automatically entering/fill data in cells in Excel 2003	dipdog	Excel	0	08-17-2006 08:37 AM
How to count cells containing data and meet certain criteria	AdamNT	Excel	1	08-11-2006 11:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:29 PM.