How to get cells to calculate time?

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 09:56 PM.