Forum home » Delegate support and help forum » Microsoft Excel Training and help » 3D formula

3D formula

ResolvedVersion Standard

Tue 18 Mar 2008, 16:35 Delegate Daissy said...

Daissy has attended:
Excel Intermediate course
PowerPoint Introduction course

3D formula

what is the easiet way to create a 3D formula

Sun 30 Mar 2008, 20:03 Trainer Mara said...

RE: 3D formula

Hello Daissy,
I hope you enjoyed your training sessions with us.

I have found another posting in our forum that discusses 3D formulas:
https://www.stl-training.co.uk/post-4823-freeze-panesd-formulas.html

If you have more specific questions on using 3D formulas, please feel free to reply to this posting and I would be more than happy to help you further. Otherwise, if it has resolved your question, please mark this question as resolved.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

3D formula

3D formula

RE: 3D formula

Excel articles

Excel tip:

Calculate difference between two times